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
You can do that with an LOD. I attached a Superstore Sample
IF [LOD] > 10 THEN "Show" ELSE "Filter" END
Then strip your detail out and filter
9.2.2 workbook attached.