how and where to Change the total formula in pivot table

[sasimk1511]

Hi,

In QS Pivot table ,my requirement is to write a custom formula for the total displayed.

Currently, I see there is an option to switch on/off the totals at dimension level. But there is no way to customize the formula, as to how this value is calculated.

Is there a way to do this. Or is there any extension?

Thanks,

Sasi

[jonathandienst]

Use Dimensionality() like this:

If(Dimensionality() = 0,   
	... total expression ...,
	... detail expression ...
)

[sasimk1511]

Hi,

Thanks for the reply. Where to use this formula. Is it in the measure? 

Below is the example of my pivot

In my example below, I have 3 measures, and I want to change the total formula for only one measure.

In example below, I want to change total formula for only accuracy