Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi!
You have extra ' -sign in first set statement.
You could also try instead of $(mon_A) try $(=mon_A)
Br,
Miikka
Climber