Percentages in pivot tables

[jen_a_scott]

Hi,

I've got a pivot table that shows customers and their YTD sales figures. I have also added the YTD sales figures in again to diplay as % of total. The problem I'm now facing is that the info is to be filtered to the top ten accounts but when I do this the percentages changes to only calculate for the ten customers rather than all of them. (If this makes sense)

Can anyone help??

PS I'm using excel 2007 and the pivot is to an external data source.

 

[Andrew Poulsom]

Excel will always use the displayed total. You could sort by YTD sales descending and hide the rows that aren't in the top ten.