| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table with added columns for evaluating results
I have added an extra column to a pivot table to analyze the results. The
pivot table is set up with a page filter for separate users. Each user can select their data to review without having to look at the entire data set which is 240 pages. I have used if statements so that the formula rin the added column runs only if there is data. However if the user selects page preview they still think their report is 240 pages long because of the formulas in the added column. Is there any way to avoid this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a Pivot Table to repeat the values in the columns? | Excel Discussion (Misc queries) | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
