Pivot Table and adding a % column, that is not in original data

M

MarkArtillery

Hi, Is it possible to add a column for % calculations when the % column is
not in original data? To clarify, my original data is as follows:

Produt Sales Returns Date
A 5 June
B 6 June
A 1 July
A 1 September
B 1 November

When I run the pivot table, one of the columns I'm then looking to get is a
total % of returns over sales , but I cant see how to include in a Pivot
table. I can add it outside of the table, but that has problems when the
table is refreshed etc, as it frequently needs to be.

Thanks for any help
 
L

Luke M

From the PivotTable toolbar, click the PivotTable button, formulas,
calculated field. Then setup the formula to be:
=Returns/Sales
 
T

trip_to_tokyo

Mark, please refer to:-

http://www.pierrefondes.com/

Items 70 and 71 towards the top of my home page.

The EXCEL 2007 file is the final version of what I have done (I think that
it gives you what you want).

The WORD 2007 file shows you how I got there.

Please hit Yes if my comments have helped.

Thanks.
 

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

Sort pivot table field (droplist) by month or original data 1
Reverse Pivot-type Data (that's not a pivot table) 2
date filter in a pivot table 1
Pivot Table 1
changing year grouping in pivot table 4
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table Set Up 2
Pivot Table Data Column Sort Excel 2007 1

Top