In this article
The figure below .- shows a typical example table designed by combining a personalized filter question with other table functionality. The report is on a grid question with 8 items in the answer list and a scale from 1-5. “Set Report Base” is “Direct Sales” (go to Setting the Report Base for more information).
Figure 1 - Example table
“Work objectives” is a grid question. In the header variable settings of that grid question .- the collapsed property is set, so the table will have one row for each item in the answer list (each statement). “Avg” is chosen in default stats, so that for the last three columns, where the grid is crossed with the personalized filter question “Department”, the averages for the different units are displayed.
Figure 2 - Header variable settings for "Work objectives" grid
The “Categories” object is used to provide the proportions of answers on the scale. In Table Properties > Distributions, Horizontal Percentages is selected. The categories results are filtered by the personalized filter, so the table only shows responses belonging to the “Current Hierarchy Level”, “Direct Sales”.
“Self” and “All parents” are selected in the reference group settings (go to Reference Group Settings for more information) in the header variable settings of the personalized filter question “Department”. This gives the current hierarchy level (“Direct Sales”) and the levels above it all the way up to the top level (that is “Sales” and “The Company”).
Note: When a hierarchical header variable that is also used as a personalized filter question is used in the table, that header variables includes the Hierarchy Layout property. This property controls the layout of the hierarchy levels (go to Hierarchy Layout for more information).