filter on pivot table grand totals

[mart10]

I am using Office 2010

I have a large pivot table of data working fine and this create grand totals at bottom of pivot table based on count of data

a b c d names

1 1
1 1
1
1 1 1

4 2 1 1 Grand total

I would realy now like to filter on the grand total - say to show anything 2 or less for example to show which names meet this criteria

Is this easily done and how?

thanks in anticipation

 

[SkipVought]

hi,

Don't really understand what you want. Filters don't work like you state.

In a table other than a PivotTable, filters would be placed on the heading row. Furthermore, the Grand Totals are NOT really part of the table. They are an aggregation on the values in the table (an added entity).

I M Really konfuzed!

[pre]
a b c d names
1 1 name1
1 1 name2
1 name3
1 1 1 name4
4 2 1 1 Grand total
[/pre]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mart10]

Well I know this regarding filters, this is why I asked the question if there is a solution

Its quite a simple concept to aggregate data and then based upon those results apply filter, just wondered if this can be handled in 2010, but it appears not then?

I have about 1500 bank accounts over numorous banks (top row) by company (left hand column) The aim of the excecise was to discover those banks holding very few accounts. I can do it very manually via filtering but this is a clunky solution - i was hpoing pivot tables were the answer

 

[SkipVought]

I can do it very manually via filtering ...

Please explain to me how you would do that.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}