Color dimension in pivot table QLiksense

[43918084]

May I know how I can color a pivot table dimension in Pivot table?

I have tried if(OnOffBS='OnBS', Red(), Blue()) but it returns below.  Many thanks in advance.

[morgankejerhag]

The formula should be added in "Background color expression" on each dimension/measure and not as a separate measure.

[43918084]

Thank you very much.  Seems Pivot table does not have "Background color expression" for Dimension.  It is only in Measures.

[morgankejerhag]

It has that in new versions of Sense - what version are you on?

[43918084]

Thank you very much.  I m still in Nov 2019, unfortunately