G
Guest
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.
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.