Using the Categories Element

In addition to the various columns of statistical data, you can extend your table to include category information, in this case the 5-point scale of the grid.

1. Drag the Categories element from the button bar and drop it into the Drop Columns Here cell beside the Statistics element .



Figure 1 - Dragging the Categories element into the table

2. Click Refresh to view the results.

The table now looks as shown in the figure below.



Figure 2 - The table with the Categories element

Note: In the table in the figure above, the rows are actually separate questions (in this case the rows in a grid). Therefore, when the results are calculated, the vertical percentages are calculated from the individual values as, for example in the first column of the Comfort row, 25 of 25. They are all therefore 100%.

3. Open the Category's Properties page and expand the Distributions property.
4. Keep the Count box checked, check the Horizontal Percents box, and uncheck the Vertical Percents box .



Figure 3 - The Category Properties Distributions options

5. Click Apply and note how the table layout has changed .



Figure 4 - The same table using the Horizontal Percents property

6. Click Save to save the changes.