| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help with pivot table
Hello,
I have an excel sheet containing data from which I need to prepare a pivot table. I want to prepare a pivot table that not only works for this sheet but is global (the only thing that would be different between the sheet would be the size of the data, header row remaining the same) The pivot should contain the product id no. and the total for that id no. Can any one please help me with this... thanks, D -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200609/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Help with pivot table
Start with your initial data, then
just walk through the pivot table wizard. (Data=Pivot Table Report and Chart) After you layout your table, then it is universal. You can right click on it, select PivotTable wizard, hit the left arrow in the dialog if necessary and change the source of the table. -- Regards, Tom Ogilvy "dinadvani via OfficeKB.com" wrote: Hello, I have an excel sheet containing data from which I need to prepare a pivot table. I want to prepare a pivot table that not only works for this sheet but is global (the only thing that would be different between the sheet would be the size of the data, header row remaining the same) The pivot should contain the product id no. and the total for that id no. Can any one please help me with this... thanks, D -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200609/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
| Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming | |||
Hybrid Mode
