Color expression makes my pivot not selectable

[beck_bakytbek]

Hi Folks,

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?

Does anybody have any idea?

Beck

[brunobertels]

Hi

Color coding should not influence pivot table

Coul you share your QVF or a sample of it with the pivot table ?

Regards

[kuczynska]

Hi there,

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.

[beck_bakytbek]

Hi Michalina,

Thanks a lot for your Feedback, in my case i am using the normal dimensions (not calculated dimensions), only my expressions consists of variables.

Beck

[kuczynska]

Hi Beck,

Is it possible to post a sample QVF?

[beck_bakytbek]

i try to create an simple example and will post it, because my actual examplen consists of customer data