Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Please find the attachment and help to create pivot table with diffrent cell colors
Thanks,
Venkat
Hi Venkat,
In the 2nd dimension, expand dimension and set background color like:
If(FieldName='Industry', green(),
If(FieldName='Registrations', yellow(),
If(FieldName='Market Share', blue())))
In expressions do the same, expand expression and set background color, can be tricky for null values and vertical dimension, maybe you have to use:
If(Only({1}FieldName)='Industry', green(),
If(Only({1}FieldName)='Registrations', yellow(),
If(Only({1}FieldName)='Market Share', blue())))
Change green, yellow and blue for the rgb codes you want for colors. And FieldName for the name of the field in the 2nd. column.
hi Ruben,
am not getting you if possible could please attach a sample >qvw file for my better understanding
thanks in advance
Venkat
Hi, check backgroud color in 'Metric' dimension and in 'Value' expression.
May not work depending on how is generated your 'Metric' dimension and for null values.
If doesn't work upload a sample to make test.