Filter Selection: Straight Table

[Purushothaman]

Hi Experts,

I have straight table with One dimension " BRAND" and 5 measures,

I would like to Keep the Dimension BRAND  'Rolls Royce' to remain on top of the row in spite of any Filter selection in BRAND.

For Eg: If a user selects BMW in Brand Filter, I would like to show the table like below:

Anyone, Please help

[MayilVahanan · Accepted solution]

Hi

If you want to keep one brand, try like below

Sum({<BRAND +={'Rolls Royce'}>}urexpression)

[Purushothaman]

Hi @MayilVahanan 

where should i key in this expression, Becz I am using calculated dimension and 5 measures in a straight table.

Should I key in on both Calculated dimension and 5 measures as well? 

Please suggest. 

Thank you!

[MayilVahanan]

Hi 

if its calculated dimension, can u pls share the sample file? or if possible, can u try to move the calculated dimension in the script as new dimension