N
Nick
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
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