7 Replies Latest reply: Jan 8, 2018 4:38 PM by Dan Coen RSS

    Hide a null dimension but keep associated calculated measure.

    Dan Coen

      Hi, I have a dimension that shows up as null but has quota information on it that I need. I want to hide the "-" but keep the 544,023 that shows up at the bottom. The problem I have is that if I click "suppress null values" under Model then the 544,023 is not calculated. How can I keep the amount in the null value but hide the null dimension itself?

       

      ModelBrandQuota
      CAPITALPLYO$0
      DEVICEPLYO$0
      DEVICECYNO0
      OPTIONSPLYO$0
      -CYNO$544,023
      $544,023

       

      So I want it to look like this:

       

      Model

      ]BrandTotal Quota
      CAPITALPLYO$0
      DEVICEPLYO$0
      DEVICECYNO$0
      OPTIONSPLYO$0
      $544,023