View original (French)

Text filters on 1 pivot table

zaboufredo59 Posted messages 30 Status Member -  
via55 Posted messages 14391 Registration date   Status Member 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 answers

  1.
    via55 Posted messages 14391 Registration date   Status Member Last intervention   2 759
     
    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
  2. zaboufredo59 Posted messages 30 Status Member
     
    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
  3. via55 Posted messages 14391 Registration date   Status Member Last intervention   2 759
     
    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