Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to know if there is a way to disable partial / total sum of values in a pivot table. I tried by checking "Total Mode -> No Totals" and in Presentation tab unchecking "Show partial sum" but it`s still not working.
I would like to have something like this:
Metric1 | 10 000 | |
Metric2_1 | 60 | |
Metric2_2 | 40 | |
Metric2_3 | 50 | |
Metric2_4 | 20 | |
Metric2_5 | 30 |
Each Metric is beeing calculated at reload and I would like to present them in a PivotTable using Indent Mode. But every time for Metric1 I get the sum of Metric2 values.
Thank you,
Razvan
Hi Razvan,
In Intend mode, it shows you the partial sums. In order to get rid of that you use the function dimensionality(). Your expression would look like:
if(Dimensionality()>1,sum(Value), ' ')
This calculates everything where the dimensionality is greater then 1 and for the dimensionality = 1 (Metric1) puts just a space.
Regards,
Oktay
Hey Oktay,
Thanks for your answer. This is partially correct , but I would like to show the value for Metric1 which is also calculated at reload time and it has a different value than the sum of Metric2...
Then you can use the same functionality:
if (Dimensionality()=1, sum(something), sum(something_else))