Hi Rich. I have had a bash at what you wanted.

Check out:-

www. pierrefondes.com

- and on top of the home page I have put a file up for you.

The PivotTable Worksheet is the one that you want (the StaticData Worksheet
is just my workings and not really relevant to you).

I have stuck strictly to what you stated but somehow I don't think it's what
you want?

Anyway maybe you want to update this posting some time.

Please click Yes if my posting has been helpful to you.

Thanks!



"Rich" wrote:

Hi,

I have an excel workbook which I want to alter using a pivot table to view
the data more easily.

The original culmns contain: A:Branches B:Products C:Number Sold D: Value
Sold E:Number Refunded F:Value Refunded

I want to end up with Branches in the first column, and Products across the
first row, with each produch showing Number Sold, Value Sold, Number
Refunded, Value Refunded beneath the product.

The Pivot Table Wizard list this instead on the wrong axis, against the
branch.

Hopefully someone understands what I mean and can help me use pivot tables
better !

--
Rich
http://www.rhodes-pefkos.co.uk