selected value in dimension

[sakamsureshbabu]

HI

my dimension  is ornament but i want show in pivot table with selected "brand"

condition is "BRAND=Y"

how can i show

[MK_QSL]

Use calculated dimension

IF(BRAND = 'Y', ornament)

and select Suppress When Value is NULL