Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table in which different entities are there. For each entity I have to apply a fixed color code.
I have applied color code however it only applies to last column.
Please find attached screenshot for reference.
In above screenshot, you may find that, only for March month the color code is applying. I want the color code must be applied to all the month.
Also in Description section Retain & scrap I want to apply the same color code.
Please find attached qvw file for reference.
Kindly provide the solution.
Thanks in advance.
You have to use set analysis in background expression to ignore selections. Use expression like:
=Only({1}if(FieldID='400',RGB(0,255,0),if(FieldID='413',RGB(255,0,0),
if(FieldID='588',RGB(255,255,0),))))
This is because of the expression you have written and the single select option that you have enabled .....
you need to tweak the expression to make this work
You have to use set analysis in background expression to ignore selections. Use expression like:
=Only({1}if(FieldID='400',RGB(0,255,0),if(FieldID='413',RGB(255,0,0),
if(FieldID='588',RGB(255,255,0),))))
This is because of the expression you have written and the single select option that you have enabled .....
you need to tweak the expression to make this work