I have attached a workbook with two options for creating views: Option 1 colors the entire background of each row by the desired color. Option 2 adds a colored column at the end of the crosstab. Option 2 is actually more complex because we first need to write a calculation for each existing column, which will allow us to add the numbers to the crosstab without coloring them.
Instructions for both methods are in the caption for each worksheet.
I hope this answers your question!
r-g-a color kpi.twbx 99.0 KB
Many thanks.It did help me