Disable total/partial sum in pivot table

[razvan_brais]

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

[itec_pao]

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

[razvan_brais]

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...

[itec_pao]

Then you can use the same functionality:

if (Dimensionality()=1, sum(something), sum(something_else))