1 Reply Latest reply on Jan 26, 2016 2:22 PM by Adam Crahen

    Count Distinct Items > $10


      I need help with a calculated field or LOD? measure to Count Distinct items in each Category(ie cat dry) for each Account if the item $'s is greater than $10 for current 6 Months.

      Therefore the 3rd line -59 would be a zero for the count and not be included.


      Objective is to have a work sheet only show accounts (NOT description or item number) down the side with an accurate count of items carried per category. See 2nd picture.

      Every time I try it I end up counting every item that sold at an account.





      IDEAL RESULT - With Accurate item counts>$10