IF expression for dynamic dimension

[#1]

Hi,

im trying to show less uninmportant data with a dynamic dimension.

the table should show item categories, but only those which content has changed.

so if a category has not changed, it should not show up in the table - but the category ID is still there.

the goal is to only show items in a dimension which meet conditions of an IF expression.

IF(

sum({<[month]={'$(mon_A)''}>}distinct data_cat)<>

sum({<[month]={'$(mon_B)'}>}distinct data_cat),

sum(distinct ID_cat)

)

The Editor shows "Expression OK" but the Table shows an error in the dynamic expression

[Gysbert_Wassenaar]

If you're using that expression as a calculated dimension then you'll have to specify over which dimensions it should be aggregated. Something like =aggr( if(......) , DimA, DimB,...., DimX)

[miikkaqlick]

Hi!

You have extra ' -sign in first set statement.

You could also try instead of $(mon_A) try $(=mon_A)

Br,

Miikka

Climber