Excel 2003
I am pretty good at pivot table but can't figure out how the have subtotals
display for my 3rd row field in under my 2nd row field - they only display at
the grand total line.
Please see the example below. I need to get subtotals for A/P and OP under
store 1 and then again under store 2.
Also My calculated field do now show up in my grand totals? why not - they
should work - the math is valid.
thanks!!!!
Div Desc Desc Ver
Store 1 4 OP
A/P
1 OP
A/P
2 OP
A/P
3 OP
A/P
Store 1 Total
Store 2 5 OP
A/P
6 OP
A/P
7 OP
A/P
8 OP
A/P
Store 2 Total
Bookmarks