if i would like to create a measure to show just sub category "Art" sales number ignoring the rest of the other sub categories,
i created this
FIXED [Sub-Category]="Art" : SUM([Sales])
However when this measure is pulled into view, the rest of the sub categories are also showing numbers. I only want to see Art. Note that i do not want to use Filters.
any help is greatly appreciated .
Can you use the below calculation?
IF ATTR([Sub-Category]) = 'Art' THEN SUM([Sales]) END
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...