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

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

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

Which EXCEL version?

"MarkArtillery" wrote:

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

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

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

--
Best Regards,

Luke M
"MarkArtillery" wrote in message
...
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

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

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.



"MarkArtillery" wrote:

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