10 Replies Latest reply: Jul 24, 2015 1:34 PM by Sunny Talwar RSS

    How to force null value into pivot table line

      Hi,

       

      I'd like to ask a little help.

      I have a pivot chart like this one below:

       

      ProductMeasureAMeasureB

      A Product

      23
      B Product35
      C Product46
      Total9-

      MeasureA and MeasureB are sum(<set analysis>Volume) expressions.

       

      I have to show null value in MeasureB column for total.

       

      Does somebody know a working solution for this? I tried with Product -= {''Total'} in set analysis but it shows zero value in the total cell, but I need null value.

       

      Thank you

      Gabor