1 Reply Latest reply on Jun 29, 2018 10:10 PM by sudheer.kumar.5

    Creating a measure

    Gavin Wong

      Hi community,


      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 .