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.