View original (French)

Some amounts in the table do not appear in the pivot table.

Solved
rimoa Posted messages 153 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   -

Hello,

I have tried several times in vain. The data from the same columns appears in the pivot table along with other names. Some are numbers while others are text.

Thank you in advance.

3 answers

  1.
    NonoM45 Posted messages 1047 Registration date   Status Member Last intervention   5
     

    Hello,

    A pivot table is only meant to work with numbers!

    If you have amounts in text format, you must definitely correct them.

    1
  2. rimoa Posted messages 153 Registration date   Status Member Last intervention   1
     

    Thank you

    0
  3. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494
     

    Hello.

    I apologize in advance for being unpleasant, but:

    @rimoa: Without your file, it's impossible to help you effectively. And when you say "other names," should we understand it as "other non"?

    @NonoM45: In my (many) pivot tables, I've always had a lot more text than numbers!

    Best regards.

    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)

    -1
    1. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494
       

      Oh yes! I was right: There is someone who found my intervention unpleasant!!!

      0