Pivot table totals using average instead of the calculation

[Jembop]

Hi, I have a pivot table where I have a measure which divides one value from another, and is shown as a percentage.
The total of this percentage column shows an average of the rows above, instead of dividing the totals of the values. Is there a way to ask the pivot to perform the same calculation on the totals, instead of averaging the percentages?

 

[GlennUK]

How have you set up your measure ... can you show screen-shots?

 

[Jembop]

How have you set up your measure ... can you show screen-shots?

The measure divides one value from another, and is set as a percentage. So, when you add it to the pivot, it defaults to SUM where the total has added up all the percentages which is ridiculous. The closest I can get is to set the value to AVERAGE but the total is then an average of all the percentages in the pivot. What I need is the total to actually just divide the total of the values from each other, the same as the non-totals are doing.

 

[GlennUK]

I added a calculated field to my PivotTable, and it works fine:

 

[Jembop]

Hi GlennUK,

I tried creating a calculation group as you have done but it's still summing the % as you can see in my grand total row.
The correct result should be 28.9%

 

[GlennUK]

I don't know what's going on with your PivotTables ... it doesn't make sense. Can you upload it somewhere to a shared location where I can take a look?