Multiple Items Identified as First Occurrence

Options
AllMartin
AllMartin Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

We have a module dimensioned by Time and Item ID. One of the Line-Items in the module is Item Category. We need to identify the unique categories. ISFIRSTOCCURRENCE seemed to be the answer but it is identifying each category as being the first occurrence multiple times, once for each period.

How can we identify the unique categories?

Thanks.

 

Tagged:

Categories