ExcelBanter - Pivot Table Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Question (https://www.excelbanter.com/excel-discussion-misc-queries/245494-pivot-table-question.html)

Nate

Pivot Table Question

Hello,

I have a Pivot Table with a field that represent gross units and returns.
Each account has 1 row representing gross units and 1 representing returns.
I'd like to add a row showing the return %, but I'm not sure how it would be
possible within the table?

Account Transaction Type Jan Feb Mar
01234 Gross 10 7 12
Returns -2 -1 -4
01235 Gross 25 15 18
Returns -3 -7 -4

Herbert Seidenberg

Pivot Table Question

Excel 2007 PivotTable
Calculated Item, %
http://www.mediafire.com/file/imzmhm...10_15_09b.xlsx

All times are GMT +1. The time now is 05:17 AM.