Advanced filters in Pivot tables ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aleblanc@magic.fr - 14 Dec 2005 09:02 GMT

Hello,

Is it possible to use some kind of formulas to filter Pivot tables,
like with the Auto-filter functionality ?

For example, I have a pivot table showing me Customer information, but
my customer codes start with a letter, then a numbering. Axxxx, Bxxx
etc... Can I filter on this field for 'all customers starting with A ?'
without having to tick/untick all records I want to see ? Or, on a date
field, all dates between say 01/01/2005 and 15/09/2005 ?

Thanks

Reply to this Message

Dave Peterson - 14 Dec 2005 15:21 GMT

I go back to the original data and insert a new column.

Then I create a formula that will help:

=if(left(a2,1)="a","show it","hide it")

or any formula that I want--no matter how complex
=if(or(left(a2,1)={"a","b","c"}),"show it","hide it")

Then I fill that formula down the column and when I build the pivottable, I use
that field as a page field. I can show/hide what I want by just changing that
formula, refreshing the pivottable, and choosing my option to show.

> Hello,
>
[quoted text clipped - 8 lines]
>
> Thanks

Signature

Dave Peterson

Reply to this Message