Pivot tables percentages

  • Thread starter Thread starter Peo Sjoblom
  • Start date Start date
P

Peo Sjoblom

There is a field setting where you can set this as "show data as % of total"
 
Revenue 1000
G Margin 550
G. Margin% 55%
It is the 55% that is coming out as wrong being addition of individul units
 
But that sets the whole colum to %, i need only that cell (row) to be %
 
You must log in or register to reply here.

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

Pivot Table percentages 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
pivot table excel 2
Pivot Table - Calculated Field - Percentage - Rept 2
Pivot Table Calculated Field - Sum/count 1
Pivot Table 2
Average of % in pivot table 1
Pivot table grand total location 1

Back
Top