Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create conditional numbers based on category and selected value

Hello! I need help with one thing. I have data for several factories which belongs to different "clusters". I want to make highlighting with conditional formatting easy. If i select a factory ...
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

I'm not sure if I understood you right, but if you slice for "FacE" the other factories will not be visible anymore.

Or did I miss something?

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

selimovd 
Yes, that is the case but that is not what i am searching for. That is why I created a separate table so that when i select something, the other alternatives will not dissapear.


When i select a factory in the highlighting table, i want all the factories from the entities/groups-table to be visible, I just want them to receive a number depending on the selection i made in the highlighting table.


Do you have any ideas on how to accomplish this?
And if something still is unclear, please don't hesitate to contact me.
Thank you 🙂

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Anonymous  What is the order of the other factories? Where is that written? What happends if I select FacC? Is then FacA 3 or is FacE 3?

    Can you share your file? That would make it easier to help you when you explain the logic you want to implement.