Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have about 10 pivot charts on a sheet that all deal with sales orders. Each chart contains Sales Order Number as a dimension. My users are asking if I can color code the order number in each chart IF the order number also exists in any of the other reports. Does anyone have a suggestion for how i could do this using a Text Color expression?
Brian,
The question is more complex than just using color expression. The real problem is that the "current" object doesn't "know" anything about the other objects. You need some global attributes of the orders that indicate that an order is going to be used in a specific front end object - and use this attribute also to define color. Another possibility is to have a set of ten dynamic variables that lists order numbers that are contained in nine charts. I cannot suggest any more details, just trying to give an idea where to go...
As for the text color expression, it most likely will be a conditional expression like:
if(<condition based on order attributes>, rgb(r1,g1,b1), rgb(r2,g2,b2))