Total of members
I have a table with Areas and countries and I want to be able to see the total per country at the bottom , regardless of the area . I should be able to see that by enabling the option "Multidimensional subtotal rows" , however that does not work. Does anyone have any idea why or how to fix it ? Thank you in advance!
0
Comments
Hi Graca, do you mean something like this?
My crosstab looks like this (Online Demodata cube Sales):
Hi Marlene. Thank you for your reply.
Yes, that's what I am trying to achive. However, with the same type of crosstab (I have a few measures in columns as well) and identical "Totals and subtotals" selected , I only get one row with Total Customer Territory and Total Customer Country, instead of Total Customer Territory and one row per country.
Please sign in to leave a comment.