Problem - Show values as % of Grand total
 

Hi,

Can someone help me with the following issue:

I created a Pivot Table with Excel 2010 that displays the sales figures of the top 10 customers. 80% of the sales comes from our top 10 customers. I added a column using “Show values as % of Grand total“. Unfortunately the displayed percentage figures are based on only the top ten customers, instead of the entire customer base.

Any help would be appreciated.

Thanks

Meni