4 Replies Latest reply on Aug 29, 2016 8:32 AM by Benjamin Greene

    Counting amount of invoice per customer

    Patrick Weber

      Hi to all Tableau experts :-)

      I have a problem which sounds very simple but I'm not able to solve it.
      I tried to count the amount of invoices for each customer.
      My worksheet has the following structure:
      column 1: customer
      column 2: invoice number

      column 3: revenues were only showed to check my filter conditions

      Filter: Only shows the value "1" of a calculated field which means the revenue of invoice is <400

       

      Example:

      ex1.png

      My aim is to get this view

      ex2.png

      If I use the cound() function to count invoices per customer the results are wrong. It seems that Tableau always sum up the revenues and if
      the value is over 400 in total for each customer the whole dataset will be kicked out.

       

      I also tried to use my flag of the filter invoice is <400 in order to get a sum for each customer but it didn't work for me.

      ex3.png

      Anyone ideas?

       

      Thanks in advance.