Formula to count the unique values in a column

In the attached screen shot of my dashboard,I want to count the number of unique values in the Item column and display the count value near the title 'Comp Reservation Details'.Any help for the formula/workaround is appreciated.

Thanks

Regards

Prabakaran

Screen_Shot_2020-10-06_at_5_86394.png

Accepted answers

All comments

rob_marshall

@praba71

Try this out....If that column is not a list, go ahead and create a list using a view with a filter using isfirstoccurrence(). In this module, create a new line item called Count with a hardcoded 1 as the value and create another line item which has the formula Finditem(new list name, Item). In a new module using the list you just created, do a sum of the count line item: SourceModule.Count[sum:line item using the Finditem()]. This will give the number of times the item has occurred.

Rob

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…