how ot show color for total based on groups in straight table ASAP

[SNR1]

Hi All,

i have values like below and need colour for total based on groups for different group need to show different color ASAP

Thanks in Advance

please help us

[Shubham_Deshmukh]

Can you elaborate more?

[SNR1]

Hi All,

based on jeery one color in output values in in my expression

for level 2 total need to show one color

level 3 for one more other color like that

[Anil_Babu_Samineni]

You can get it using work around. Will you provide sample to test?

[ahmed_hassan]

Check that, maybe it fulfill your needs.

[Shubham_Deshmukh]

Do some Resident Load stuff with your data like below,

data:
load * inline
[
A, B , C
X, 2, 4
Y, 3, 7
];
Concatenate

LOAD 'total' as A,sum(B)as B,sum(C)as C Resident data;

This will add total of you columns at the end and then you can set background color (with condition =if(A='total',Red())) from expression tab, hope you are expecting this as below,