Pivot tables
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 |
Pivot tables
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 "Nick" wrote in message ... 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 |
Pivot tables
Bernie
just done it....worked a treat! that had bugged me for years! Thanks a lot! Nick "Bernie Deitrick" wrote: 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 "Nick" wrote in message ... 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 |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com