It would be great if Grand Totals on a Matrix or Table would add up correctly to the sum of the rows when you include MEASURES in the visual. Currently the total on a measure consists of the measure function itself, instead of the sum of the rows above. PLEASE give us the option to toggle totals to be a simple aggregate of the rows above also.
- Comments (1)
Comments (1)
RE: Matrix/Table grand totals with Measures
Total Mode
1. No Total
2. Expression Total
3. Sum of rows
Maybe the third option can be a dropdown where we can choose Sum/Avg/Min/Max etc