i got a situation, i use 2 Dimension and 5 Expression in my Pivot-Table:
behind of my all expression i implement the RGB_Code like: if (Sum (...) > 95, rgb(102,204,0),rgb(255,255,255)), all my expressions do work well, but my dimension within my pivottable not selectable, i mean, nothing moves within my Pivot.
Has the color_expressioncode an influence on my pivot?
Re: Color expression makes my pivot not selectable
Are your dimensions calculated dimensions by any chance? I had this issue before and this was caused by me using calculated dimensions. Once moved to the load script and re-called in the chart as a standard dimension it was all back to normal.