Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i am trying to restrict some values in my pivot table.
however i seem to recieve null values in my result;
i have attached the application to show the behaviour.
is it possible to use if statements on Dimensions to restrict data?
Best,
Bradley
Yes, you can add calculated dimensions based on if, such as IF(FieldName = 'XX', FieldName, NULL()) and then suppress nulls on that dimension.
However if it is a simple if expression like that, you would be better off adding a flag in your dataset and using that in your expressions as set analysis
Hi,
Check the Suppress When value is Null.
Regards,
Celambarasan