9 Replies Latest reply on Mar 29, 2016 2:28 AM by Mahfooj Khan

    Count D(customer name) if sales>0

    Sunil Rai

      I pull out customer name and then filter by those who have sales above 0 and I get a certain number.

       

      When I do up a calculated field if sold qty>0 then countd(customername) and this returns me the whole customer list (including those who have zero)

       

      Any idea how to get around this issue? I need a calculated field showing a distinct customer count for those with sales above 0.

       

      Cheers,

      Sunil

       

      I have attached a simple sample. the 2nd page is the number that I want to pull out. It comes out as 10 when its not supposed to be. I want to do this without touching the filter.