2 Replies Latest reply on Sep 17, 2018 3:05 AM by Nandan Kumar

    Difference in list and calculated field

    Nandan Kumar

      Hi,

       

      I am trying to calculate number of emails who have spent $5 or more in a calendar month. When I create a table I get the correct volume, but when I use a calculated field to find just the counts it actually takes up all the emails (including those who have spent less than $5).

       

      Taking example of superstore, I want just the counts of customers with sales greater than $50. I have a calculated field used as a filter where if sum[sales] > 50 then 1 else 0. When I drop customer on row bar, I get the correct list. But if I use a calculated field (here countd(customers)) then I get overall customer volume. Where am I doing mistake?