Having trouble creating a calculated dimension color for a line chart. In the attached file, I have an example where the code works for a straight table / pivot table; but does not work in the line chart. In the line chart, I have put the code in the “axis” tab, and in the dimension color; it does not work in either place. Does anyone have any suggestions?
The straight table in the attached file is correct and the way I want it, the line chart is not correct.
Thanks