Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.