| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table static columns
Hi,
You can try to use a calculated item formula inside the pivot table. -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "BrianR" wrote in message ... Is there a way to add static columns to a multi-worksheet pivot table? My multi-worksheet pivot table is working fine, but I would like to carry one or two additional columns of raw data into my pivot report without summing or counting them. I only want to count the first 2 colums and show the associated data in the next two columns. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| How do I save a pivot table as a static excel file? | Charts and Charting in Excel | |||
| Pivot table turning static in Excel 2007 | Excel Discussion (Misc queries) | |||
| Making a pivot table report static. | Excel Discussion (Misc queries) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
