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.

Filter Totals in a Pivot table?
 

YOu can filter the values in Excel 2007, but not in earlier versions.
If you have Excel 2003 or earlier, you can use the Top 10 AutoShow
feature to show a specific number or percentage of the items.

Or, you could use an AutoFilter outside of the pivot table, such as in
an column to the right, with links to the grand total column. Filter the
column that contains the linked values, and it will filter the pivot table.

Matt D Francis wrote:
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.




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Filter Totals in a Pivot table?
 

OK thanks.

"Debra Dalgleish" wrote:

YOu can filter the values in Excel 2007, but not in earlier versions.
If you have Excel 2003 or earlier, you can use the Top 10 AutoShow
feature to show a specific number or percentage of the items.

Or, you could use an AutoFilter outside of the pivot table, such as in
an column to the right, with links to the grand total column. Filter the
column that contains the linked values, and it will filter the pivot table.

Matt D Francis wrote:
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.




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html