| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter Totals in a Pivot table?
Hi
I have a pivot table generated from a piece of software over an ODBC link. The table is fine but is there a way in which I can filter the Grand Totals? data looks something like (ID = Row) Year = Columns Cost = Data (sum) ID Year Grand Total 2006 2007 B123 10 5 15 C133 1 9 10 D156 15 21 36 and I want to filter in some way to see rows only where Grand Total <=15 ?? Remember I can't define this at source as I do not see the underlying data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Pivot Table and totals | Excel Worksheet Functions | |||
| Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
| Pivot Table % of Totals | Excel Discussion (Misc queries) | |||
| Pivot Table Totals | Excel Discussion (Misc queries) | |||
| Pivot table totals | Excel Discussion (Misc queries) | |||
Threaded Mode
