Totals for all columns in pivot table

[Anonymous]

Hi, I have this pivot table where the second column are my expressions.

How can I get a Big Total so it looks like this, instead of partial sums by dimension

Thanks in advance!

[jayanttibhe]

Hi

can you please share the sample app with data ?  It will be lot easier of you calculate the fact data based on 2 OR many countries in the data model itself.

[vishsaggi]

In Presentation tab - Select your 2nd dimension - Then check show partial sums option - then give Label as Thin Clients in Labe for Totals text box. Like below:

[uacg0009 · Accepted solution]

Hi Oscar,

If user don't need to filter the first and second dimension, I think you can use valuelist() to do the dimension, like

valuelist('US','CA','Total').

And also change the expression.

But if you have filter about the dimension, I think I need to find another to solve it.

Aiolos

[Anonymous]

Hi Aiolos, thanks for your answer, the user won't be filtering the dimensions, what my expression should look like? I guess I need an IF or set analysis to filter based in the valuelist

[Anonymous]

I got it working, thanks Aiolos! the valuelist did the trick

[uacg0009]

You're welcome, glad to help you~