on fly pivot table measure background color issue

[satyaprakash]

Hi All,

We are building dynamic pivot table with a large number of columns(around more than 100). Columns are activated or deactivated based on expression in  'qCalCond'. 

As chart is dynamically generated some fields will have calculated expression as 0 in 'qCalCond'. Then, some of the measure columns background color is not coming (below screenshot).

 But if are making dimensions and measures fields as static (either using only dimensions which are required for plotting chart for that selections or making 'qCalCond' as 1 for each dimension and measure). Then it is working fine. Below attached screenshot.

Any solutions for this.

Regards,

Satya

[anushree1]

Could you please share a sample application, also try using the only keyword in your expression  

[satyaprakash]

Attaching sample mashup folder

[satyaprakash · Accepted solution]

This issue we fixed through apply patches.