UPCOMING WEBINAR: From Thousands of Tables To One Clear Story: using AI in survey analysis This article describes how to go from a table with statistics below...
...to a table where specified statistics from below are placed as rows at the top:
Requirements
A table.
Method
- Select your table.
- Go to Data > Rules in Properties
.
- To apply the rule, select the Plus (+) > Sort/Reorder > Move 'Statistics - Below' to Top.
- OPTIONAL: Tick Shade rows if you wish to shade the statistic rows differently. You have the option of choosing a Primary color and Secondary color. The rows in the table will be shaded alternately.
- OPTIONAL: Tick Rename statistics if you wish to change the name of the added row statistics. You will have the option of selecting the statistic and entering the New name.
- OPTIONAL: Tick Always show sample size (whichever is appropriate for each table) if you wish to automatically add the most appropriate sample size statistic to your table as a row without having to specify it.
- Tick Choose statistics to place at top to specify any further statistics to show by selecting them in the subsequent drop-downs.
Note, when this option is not ticked, all statistics from Statistics > Below will be migrated to the top of the table. Also, the order of the rows will be the opposite of the order in which the rows are normally shown in Statistics > Below.