on 06 Oct 2018 02:13:57
There should be an option to have the aggregation used in the totals row be separate from the aggregation used in the rest of the rows. For example, the ability to have the aggregation for table values be an average, but the grand totals show as a sum of the averages above. Currently, you have to create a measure to do this, but it would be easier and more streamlined if you could control the aggregation showed in the totals row for each column value.
- Comments (1)
RE: Change Totals Aggregation in Tables/Matrix
As well as the ability to turn off an aggregation at a particular level. Like if I want a sum at a certain group level, but at the Grand Total level, the aggregation is meaningless/confusing.