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

    Count Distinct Items > $10

    kelly.schmittel

      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