Problem - Show values as % of Grand total

M

Meni

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to ignore a column of numbers in Grand Total for rows 1
Assistance need to populate "GRAND TOTAl" "MSpivottable11" in Microsoft web component 0
Difference between 2 calculated fields showed as % of grand total 0
Show only Grand total in Pivot Table 0
Difference between 2 calculated fields showed as % of grand total 0
how to make grand total to show up on pivotchart? 0
Display of totals in Pivot Table Columns 0
Calculating a grand total for an unbound control in a report 9

Top