smmedeiros
Technical User
I'm working on a cross tab report where i have 4 variables I've placed in a crosstab
Manager
Name
Door
Access Flag
in the row section
Manager
Name
in the column section
Door
in the summarized Section
Mode of Access Flag
The results are what I expect, simple table showing
Manager --> name and population of data value "yes" if access flag=yes
The columns have 4 possible doors.
because I'm grouping by Manager (and this is a need to seperate them),
the first cross tab where I have team members with access to all 4 doors show all 4 columns.
I then move to the 2nd manager where the team members have access to only 1 door. so, only 1 column shows
i then move to the 3rd manager where team members have access to 3 doors, hence 3 columns
back to a manager who has team members with access to 4 doors, hence 4 columns.
the door names will be consistence for all manager combinations.
is there a way to have each cross-tab section display all 4 door columns regardless if the team member has access to it?
desired output
door names across top in columns
manager name in row followed by employee name
access flag in summarized field
door1 door2 door3 door4
Manager1
name1 Yes Yes Yes
name2 Yes Yes
name3 Yes Yes Yes Yes
name4 Yes Yes
name5 Yes Yes Yes Yes
name6 Yes Yes Yes Yes
name7 Yes Yes Yes
door1 door2 door3 door4
Manager2
name20 Yes
name21 Yes
name22 Yes
name23 Yes
name24 Yes
name25 Yes
name26 Yes
door1 door2 door3 door4 Response
Manager3
name30 Yes
name31 Yes
name32 Yes Yes
name33 Yes
name34 Yes Yes
name35 Yes
name36 Yes
in addition, is there a way to add a 'blank column' at the end to allow after export, someone to type in the field to track a response?
Thanks in advance for any help, ideas or suggestions.
Manager
Name
Door
Access Flag
in the row section
Manager
Name
in the column section
Door
in the summarized Section
Mode of Access Flag
The results are what I expect, simple table showing
Manager --> name and population of data value "yes" if access flag=yes
The columns have 4 possible doors.
because I'm grouping by Manager (and this is a need to seperate them),
the first cross tab where I have team members with access to all 4 doors show all 4 columns.
I then move to the 2nd manager where the team members have access to only 1 door. so, only 1 column shows
i then move to the 3rd manager where team members have access to 3 doors, hence 3 columns
back to a manager who has team members with access to 4 doors, hence 4 columns.
the door names will be consistence for all manager combinations.
is there a way to have each cross-tab section display all 4 door columns regardless if the team member has access to it?
desired output
door names across top in columns
manager name in row followed by employee name
access flag in summarized field
door1 door2 door3 door4
Manager1
name1 Yes Yes Yes
name2 Yes Yes
name3 Yes Yes Yes Yes
name4 Yes Yes
name5 Yes Yes Yes Yes
name6 Yes Yes Yes Yes
name7 Yes Yes Yes
door1 door2 door3 door4
Manager2
name20 Yes
name21 Yes
name22 Yes
name23 Yes
name24 Yes
name25 Yes
name26 Yes
door1 door2 door3 door4 Response
Manager3
name30 Yes
name31 Yes
name32 Yes Yes
name33 Yes
name34 Yes Yes
name35 Yes
name36 Yes
in addition, is there a way to add a 'blank column' at the end to allow after export, someone to type in the field to track a response?
Thanks in advance for any help, ideas or suggestions.