Avoiding the same priority values for different items
Hello everyone,
I am facing a wall regarding a dev…
Here is the need, i have one table, with a dimension called : Layer 3
This table is published in a dashboard, where users can imput data on the column "Layer L3 Priority" displayed in yellow.
Now, i was asked to do the following : "We don't want the user to imput identical priority values for two differents (or more) items.
For instance, we don't want the CTO items to share the same L3 Priority values, or the VIPs, or the CTO item and the VIP item… tried to do something with ranking to make them unique but i'm stuck here
Any help would be appreciated
Best
Best Answer
-
Use ISFIRSTOCCURRENCE function to flag the first occurrence of each items and for duplicative items it shows FALSE, You can highlight the duplicative items using conditional formatting.
1
Answers
-
you can potentially use IsFirstOccurrence() and if that result is false, you can highlight that value.
0 -
Thank you very very much ! it did solve the problem ! :)
0