Restrictions syntax on dimension pivot table

[#1]

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

[calvindk]

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

[CELAMBARASAN]

Hi,

Check the Suppress When value is Null.

Regards,

Celambarasan