Pivot tables

[Guest]

Example data

Product Date Volume Value

Product A 25/11/05 10 200
Product B 25/11/05 15 240
Product C 25/11/05 12 130
Product A 25/11/05 18 260
Product A 26/11/05 12 130
Product B 26/11/05 19 240

I want a pivot table that looks like this:

I have to do 2 separate pivot tables and merge then together.

Product A Product A Product B Product B Product C Product C
Date Volume Value Volume Value Volume Value

25/11/05 28 460 15 240 12 130
26/11/05 12 130 19 240

I want to the pivot table to show, so that Volume and Value for each PRODUCT
are in COLUMNS side by side.

If a create a pivot table with the wizard

· move Product in ‘Column fields’
· move date to ‘row fields’
· move volume and value in ‘data items’


At the moment Excel, puts the VOLUME and VALUE in separate ROWS in the same
column, like below:

Product A Product B Product C
Date

25/11/05 Vol 28 Vol 15 Vol 12
Val 460 Val 240 Val 130

26/11/05 Vol 12 Vol 19
Val 130 Val 240

Anyone got any ideas???

Thanks

 

[Bernie Deitrick]

Nick,

Create your pivot table, then grab the data button, and drag it to just underneath the column
headers. When you get a 'ghost' insertion cursor, let go of your mouse button...

HTH,
Bernie
MS Excel MVP

 

[Guest]

Bernie

just done it....worked a treat!

that had bugged me for years!

Thanks a lot!

Nick