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
 
Ad

Advertisements

L

Luke M

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

Advertisements

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

Top