| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table help.
I have a large file which I have simplified below:
acct name actual budget variance 3010 soda sales 200 150 50 6010 soda exp 125 100 25 I am trying to create a pivot table that would enable me to select certain account numbers and see the actual budget and variance columns of data...I want to be able to select 3010 and see the name the actual, buget and variance. I can create a pivot table and get actual OR budget OR variance to appear in the data field but cannot get all 3 to appear. Most samples I have seen are only working with pulling one column of data. |
| 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) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | 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 | |||
Threaded Mode
