Unique Count in Summary

How do you write a formula that takes the UNIQUE count of values in the summary. For example: Product A: Rep 1 and Rep 2, Total = 2 Product B: Rep 2 and Rep 3, Total = 2 Product C: Rep 4, Total = 1 At the summary level for all products, the count of reps would be 5 however, the count of unique reps is 4. How can you get the unique count of reps at the summary level?

Accepted answers

nathan_rudman

Oleg, if you have an "easy" solution I'm curious because to my knowledge there is no "count" function.

Victoria, if you want only unique associations to be created, use numbered lists. To count, you have to use some tricks, unless Oleg can light our way.

All comments

nathan_rudman

Hello,

If I may say, your question is unclear, very much so.

PrevContributor

I don't believe it's unclear at all. I'm asking for a unique count in the summary items.

If Bob and Joe sell apples,
and Bob and Chris sell oranges,
at the summary item which would be fruit,
what is the unique count of reps selling fruit?
The answer would be 3. In today's world, the summary count of reps selling fruit is 4

nathan_rudman

ok let's ask precisely then:
- what do you call summary ?
- what are fruits ? hierarchy, line items ?
- what are the reps ? hierarchy, line items ?
- what's the relationship between those two ?(technically) ?

zimin-oleg

Victoria, Seems it's very easy case
Have you solved it?

PrevContributor

No I have not solved it. If you can figure out a way then that would be helpful

PrevContributor

Fruits and reps are both in hierarchies. The relationship is that fruits are assigned to reps to sell.

nathan_rudman

PrevContributor

Count1 is my first module, with Products and Reps lists, and one Line Item (Sell).
Count2 is my second, with only the Reps lists and one Line Item (Count).

Count2_738.PNG

Count1_738.PNG

PrevContributor

Victoria, Eric's response above is certainly the best solution to your problem.
Notice that the calculation used in the second line item makes sure that a rep will only be counted if they have some product assigned to them to sell, so this should solve your problem perfectly.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…