Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart with a calculated dimension including if statements
e.g.
[...]
IF( AGGR( | ||||
COUNT( | ||||
{< | ||||
data_type_key={'profitability'} | ||||
,version_single_key={'Actual'} | ||||
,%measures_key={'$(v_select_measure)'} | ||||
,period_year={'<$(v_select_mr_end)>$(v_select_mr_start)'} | ||||
,fiscal_year | ||||
>}material_count_key | ||||
) | ||||
, | ||||
material_count_key | ||||
) > 50 |
,
DUAL('>= 3.500 EUR and > 50pcs', 2) |
[...]
Now I would like to color all elements with '>= 3500 EUR and > 50pcs' red.
But how can I refer to a calculated dimension?
Thank your for your help.
Best
Simon
Use this may be for the background color of your dimension:
IF(AGGR(COUNT({<data_type_key={'profitability'},version_single_key={'Actual'},version_single_key={'Actual'},%measures_key={'$(v_select_measure)'},period_year={'<$(v_select_mr_end)>$(v_select_mr_start)'},fiscal_year>}material_count_key), material_count_key) > 50, Red())