View original (French)

Text filters on 1 pivot table

zaboufredo59 Posted messages 30 Status Membre -  
via55 Posted messages 14730 Registration date   Status Membre Last intervention   -
Hello,

is it possible to use a text filter on a pivot table?
on a normal table it works!!
because I have a table extracted from a database and I don't want to retype it
by renaming fields.
is there a trick, thanks

Configuration: Windows Vista / Chrome 39.0.2171.71

3 réponses

Réponse 1 / 3
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Hello

In a Pivot Table, in the filter at the top of the column, there is a row "Filter applying to labels" which is a text filter

Best regards

--
"Imagination is more important than knowledge." A. Einstein
0
Réponse 2 / 3
zaboufredo59 Posted messages 30 Status Membre
 
thanks via 55,
ok I saw.
but I have another issue.
in a normal table you can select text filters then custom filters and then you have 2 lines of choices for example begins with
then and (or) or for example begins with; super handy!!
especially in my case where only one and the same salesperson has been entered e.g.: MARTIN
and P MARTIN.
except that when you created your pivot table from this table then you only have
the choice of: filters applying to labels and then you only have one criteria to choose from, it's weird.
I can't find it, thanks for your help.
0
Réponse 3 / 3
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Re

Yes, indeed there are not 2 possible choices in the pivot table filter
Maybe he knows a trick in VBA or something else?

As for your case, you can still manage with the only filter Contains: MARTIN

--
"Imagination is more important than knowledge." A. Einstein
0