Forum Discussion

PabloML's avatar
PabloML
Regular Visitor
2 years ago

Conditional formatting for a matrix with 2 calculation groups

Dear all,   I have created a matrix with 2 calculation groups. In Rows I have a calculation group for every KPI, and then in columns I use the other calculation group for different measures (like Y...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PabloML ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

 

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PabloML's avatar
PabloML
Regular Visitor
2 years ago

Thanks, Anonymous for this.

 

Well, right now I have something like this:

 

And I'm looking to have something like this:

The matrix contains 35 KPIs and there are 5 "major" KPIs that I don't show any value but I want to color the background on the entire row as you can see in the second image.

 

Hope someone can give me a tip on how achieve this.

 

Thanks for your time.