7 Replies Latest reply: Jul 29, 2015 9:20 AM by Gabor Szikszai RSS

    Show null value in pivot table instead of 0 for specified row

      Hi All,

       

      example.PNG

      I have a table which contains several reports (left table). I have to create a pivot table (right one), and I need to show only ReportA but I have to show zero values also and the Total should be null value. (Total is a row in the table and not necessary the total of the Products)

       

      I have created an if statement (if(Product='Total', null(), sum(....)).

      I remove the tick from the checkbox on Presentation tab named Suppress Zero values.

       

      But when I did this ReportB appears in my pivot table as you can see on the right table. Is there any solution if I want to show null value for the specified row but I have to use set analysis in the expression?

       

      Thanks for you time and help!

      Gabor