3 Replies Latest reply: Sep 6, 2012 2:29 AM by Mayank Gupta

# Help with Pivot table

In Pivot table if we have selected to show the partial sum then it automatically sum ups the group values, is there any way to skip this. I want to show the total but not the summation of group values, some other mathematical calculation result; is it possible.

• ###### Re: Help with Pivot table

Hi Ram,

Can you forward a sample application.

Regards,

Tom

• ###### Re: Help with Pivot table

Hi

You can use Dimensionality() to identify the total rows and create an expression that use Dimensionality like this:

If(Dimensionality() = 0, <total row expression here>, <detail row expression here>)

If you have more than one dimension, then the value of Dimensionality will equal the number of dimensions for the detail rows. The partial sums will have Dimensionality values between one less than the number of dimensions to 0, according to the partial sum level. The total row, or partial total row expression will often be a Sum(Aggr()) type of expression.

Hope that helps

Jonathan

• ###### Re: Help with Pivot table

Hi Ram,

Please find the attached table and let me know if you require the result as follows.

 Afghanistan Olivier Simenon 2007 2150 Albania John Lemon 2006 6000 2008 2590 Armenia Mario Kaddafi 2007 1850 Australia Rolf Wesenlund 2005 1030 2006 1210 Total 14830

Regards

Mayank