calculations within a pivot table

  • Thread starter Thread starter ceepee
  • Start date Start date
C

ceepee

I have a simple pivot table with just one column of data that is "gran
totalled" at the bottom. I need to insert a formula that will give m
a 2nd column of data which shows the first column as a % of the total.

E.g.

fixed 20 20%
can't be fixed 40 40%
to be fixed 30 30%
not tested 10 10%
Grand Total 100 100%

Any help would be much appreciated. Thank
 
Hi Ceepee,
very simple . . when setting up the layout of your pivot
table, drag the Amount into the data section and set that
as a sum of Amount. Then drag the Amount into the data
section again, rename it, set is as a sum of Amount, then
select the options button on the Pivot Table Field form,
and under "show data as" field, select % of total.

HTH
 
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

How do I perform extended calculations in a Pivot Table in Excel 2 4
Countifs or a pivot 1
Custom Calculation in a Pivot Table 1
Referencing a pivot tables Grand Totals Column 1
Pivot Table Grand Total Plus Calc Field or GT Running Balance 6
Pivot table grand total location 1
How do I calculate percentages in a pivot table? 1
Pivot Table lookup 1

Back
Top