4 Replies Latest reply: Apr 12, 2018 9:32 AM by Pasquale Cosimato RSS

    How to show zero values in pivot table

    onur yilmaz

      Hello everyone,

       

      I have a pivot table;

      producer and product as a row, scenarios on column which can be selectable from the left top of the selections and as a measure I have quantity and price values.

       

      When  I have select a producer from the producer filter which has no values for  selected scenario, I am only able to see scenairos which has the data have, for the below picture I am not able to see 'AC 2018' values for the selected 'Producer'.

       

      What I want is even if there is no value for the selected scenario, I want to see zero values for the selected scenario.

       

      For example; for the below picture 'AC18' , 'OP18'  and 'AC17' selected from the scenarios and I have also selected a producer which has no data for scenario 'AC18'. I am only able to see 'AC 2017' and 'OP 2018' in pivot table but I have also want to see 'AC 2018' column as zero. How can I solve this problem?

       

      Ps: For the below picture 'Producer ', 'AC 2017' and 'OP 2018' values have been hidden. I mean, there is values, I hid them.

       

      quantity issue.png

       

       

      Please suggest me any solution if anyone of you gone through the same problem. Any help will be appreciated.

       

      Thanks in advance.

      OY