Straight Table with only rows where a value in a column equals a text string

[brf10043]

How do I use a calculated dimension to only return rows where the value in a specific columns = a specific value in a straight table?

[Roop]

Use sum({$<ColumnName={RequiredTextString}>} Sales) as your rule in the expression and ensure that Suppress Zero Values is checked on presentation (which is default) - The examples are all in Set Analysis on the help page.