Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using Pivot table with 3 dimension and 3 measures in which 1 Dimension is pivoted. Need to show the multiple background color for pivoted dimension.
In the above attachment Year is highlighted with multicolor for example.
Hi,
Use in "Background Color" the following expression:
pick(match(Year,2008,2009,2010), rgb(255,255,0), rgb(255,167,122), rgb(175,165,255))
Regards,
David
Dear David,
Thanks for your immediate response.
In our case year is dynamical value. We can't strict to mention the value of the year.