FAQs

Go the Criteria tab of your analysis. Add any column to the report. You can choose any field.

• For that field select “Edit formula”
  
• Replace the existing formula with: MAX(RCOUNT(1))
  
• You should also rename the column so that others who see the criteria of this analysis know what the column is being used for.
  • Check the box for “Custom Headings” and then rename the “Column Heading” something like “Row Count” and click OK.
    
• Go to the Results tab. You should now see the new column with the same number in every row. This is the total number of rows for the report.
  

At this point if you no longer need to see this number, you could simply delete the column. Or, if you wish to preserve this number somewhere else in the report you could move the number to the top.

• To do this, in the Table box all the way to the right, click on the pencil for “Edit View” (next to the “View Properties” icon).
  

In the Layout window hover your mouse over the name of the column you renamed “Row Count” and drag the column from “Columns & Measures” up to the “Sections” row.

Then in the upper right corner click Done.

You will now see that the column is gone from the report. And now the count of the number of rows is at the top.

You should add a column name to make it more meaningful.

• To do so, once again in the Table box all the way to the right click on the pencil for “Edit View” (next to the “View Properties” icon)
  
• Then in the Section where the Row Count column is, click on the icon for "Section Properties".
  
• In the "Section Properties" window under "Column Heading Display" click on the second option to put the column name on top or the third option to put the column name to the left. In this example I selected the third option
  
  
• In the upper right corner click Done:
  
• You will now see the row count with the name of the column at the top of your report: