Conditional Formatting according to the dimension selection.

Apliqo UX
1

Hi,

I need to define a conditional formatting. But it should work if and only if the “GM%” is selected from the measure filter.

As you can see below currently it works even the FTE is selected. Is it possible to define this kind of a condition? As far as I understand we can only define a condition based on the cell value of the same column or cell value of another column in the view. Can we define it for a dimension selection?

image
image1820×361 124 KB

I have tried something like this “=IF($<<Forecast.GP Time Allocation m.GP Time Allocation m>> = “GM %”,1,3)” in an inserted column but it doesnt work.

2

Ir’s possible but you need to be creative. Setting service variables are recognized only withing the context of arguments within a DBRW formula. So you could insert a column and do a DBRW to the element attributes cube of the dimension that GM% is from so that the column value for all cells returns the value of the filter. Then you can use this value for your conditional formatting.

2 Likes