Okay, I'm not that new to Pivot Tables, but normally when I create them, I
just live with what I can't figure out.

Now I'm wanting to really create some very specific ones.

I need two pivot tables that I will be printing essentially as reports.


My data looks like this.


Store Item Size Qty Price Extension
1 ABC 32 2 9.00 18.00
1 ABC 34 2 9.00 18.00
1 AXX 32 1 10.00 10.00
2 ABC 32 1 9.00 9.00


Okay, what I want is Pivot table that looks like this:


Item Size Price Extension
32 34
ABC 3 2 9.00 45.00
AXX 1 10.00 10.00
Total 55.00


So basically a pretty normal PT but I would like the Price and Extension to
be on the end after the real column data which is the sizes. I know I can
add formulas after the real PT but is there a better way?


Second PT.

Store Qty Exten
1 5 46.00
2 1 9.00
Total 6 55.00


Hopefully things will line up pretty good so you can see what I'm looking
for.

Thanks for any help you can give.

Alan Sawyer