Filtering out records in a Table Dimension

[#1]

Hi

I've a table with two columns. The 1st column is Account name and the 2nd column is account sales.

Accounts have an attribute called account size which has 3 distinct values, Big, Medium and Small.

I've used dimension (not measure) for 1st column to show all the account names.

Is there a way to apply filters on the field Account name (dimension) to display only those accounts that have account size = Big?

Thanks

[sunny_talwar · Accepted solution]

Try using a calculated dimension

If([Account Size] = 'Big', [Account Name])

[#3]

Thanks Sunny. Highly appreciate your help..!