Multiple Items Identified as First Occurrence

AllMartin
Occasional Contributor

Multiple Items Identified as First Occurrence

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.

 

1 REPLY 1
rob_marshall
Moderator

Re: Multiple Items Identified as First Occurrence

@AllMartin 

 

Ideally, isfirstoccurrence() should not be used in a multi-dimensional module, but rather a module dimensionalized by a single list, in your case Item ID.

 

Give this a try:

 

I have created a silly module, but something I think might be close to what you have.  I have Invoices in my rows and Time in my columns, with one line item (Colors) that is list formatted.

 

2021-09-09_15-18-47.png

 

I then created a new module, only dimensionalized by Invoices, your Item ID.  Created a line item, list formatted as Colors with the following formula: TIMESUM(AllMartin Data.Colors)

 

TimeSUm works well here because in the second module, Time is not part of the module.

 

2021-09-09_15-21-09.png

 

2021-09-09_15-20-59.png

 

So, this is essentially returning the Color defined for the Invoice.  If invoice 33333 for Jan 16 was blank, the above would render Green for 333333.

 

2021-09-09_15-24-11.png

 

2021-09-09_15-24-30.png

 Does that help?

 

Rob