SUBTOTALS FOR SOME METRICS AND NOT FOR OTHERS

Hi All,

This will be a quick post. Yesterday, I stumbled upon an issue where I was requested to show subtotal for some metrics in the table where as not to show subtotal for other Metrics.

Thing to highlight was that all of the metrics were aggregated by default in RPD.

Now one might be tempted to:

* Go to the results tab, then edit the table view.
* In the Columns and Measures section, choose if you want the totals to display after or before.
* Click on the mouse icon on the metrics, where you want to display the totals for, and choose aggregation rule as sum, and none for the metrics that you dont want to display the totals for.

Strangely, this might work in some case, while in some cases it won’t. You might see NULL in those columns where you didn’t want subtotals

The trick lies in going to Criteria Tab once again, go to the metric you don’t want the total on, and then select

Aggregation Rule (Totals Row) as None

Run the report once again. You will see few metrics showing totals whereas few metrics not showing subtotals, as intended.

Another thing to note is that this would not have been the issue in Pivot table at all. But I wanted to refrain from using the same lest TMP tables would have been created as my dataset was large.