| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to do the filter when applying formula to a pivot table
I extract the data from one query into one pivot table from Access. I
would like to know the "Gap" or "different" (such as revenue gap from 2007 to 2006), so I insert a "calculating item" to pivot table. Beside that, there is one more condition, that is I would like to know some specific items, not all data. but when I apply this calculating item, all data is show off. I don't want to show all data. It seems the filter or selector disable. Is there anyone could help me? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Filter Formula | Excel Discussion (Misc queries) | |||
| Formula in Pivot Table Filter? | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Applying Percentages to a Pivot Table | Excel Discussion (Misc queries) | |||
| HELP PLEASE! - APPLYING A % COLUMN TO A PIVOT TABLE RESULT | Excel Discussion (Misc queries) | |||
Threaded Mode
