Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have three straight charts, all have common Dimension i.e. Client and one expression each. The requirement is if the Client Name appears twice in all three charts then make the background color of Dimension and Expression as Blue, if it appears three times make it Green other wise no color. Applying color coding on object level could work but not sure how to consider three objects at a time and rest of the objects on the sheet should not get affected.
Thank you for any suggestions.
Hi
What are the three expressions?
As what I think you will have to do is somehow merge them into a single expression to do your colour coding on each straight Table Charts by looking at the data.
Best Regards, Bill
All three are very similar:
=sum({<Week={"<=$(vCurrWeek)"}, Year={$(vCurrYear)}, Region={'Americas'}>} Sales)
=sum({<Week={"<=$(vCurrWeek)"}, Year={$(vCurrYear)}, Region={'Europe'}>} Sales)
=sum({<Week={"<=$(vCurrWeek)"}, Year={$(vCurrYear)}, Region={'Asia'}>} Sales)
One thing to add here is all these charts are being limited (through Dimension Limits) to Top10 Sales.
Or writing a Macro would be a better idea?