Matrix/Table grand totals with Measures

[p_lamonica]

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.

[fbcideas_migusr]

I don't know @Jeroen ter Heerdt, I specifically asked that question regarding visual calculations fixing measure totals and was told something different.

[cabc3]

vote 657 😁

[fbcideas_migusr]

Voted 693

[chandravr]

Inforiver provides you options to configure totals the way you want, out of the box. Totals can be aggregated easily using the option - Row Aggregation Type. Learn more in this blog.

[yelmaadoudi]

Why does something logical needs time to be available?? Please make the necessary, thanks in advance.

[fbcideas_migusr]

Vote 829.

[mark_elleray]

I have just had to explain this to the current client.

Needless to say his answer can be summarised as what a silly

[Robert_A_Charlt]

I think this is silly and would downvote it if I could. If your measure doesn't give you what you want on the totals row, then you're using the wrong measure. The solution is to rewrite the measure rather than having two separate behaviours for totals in tables/matrices.

[cabc3]

vote 857.

[fbcideas_migusr]

Vote 867.