7 Replies Latest reply: Oct 27, 2014 5:41 PM by Satish Kamath RSS

    Display Pivot when no values

    Satish Kamath

      Hi all

       

      I have pivot as below

       

      Country    State    Sales

      USA          NJ           -

                       CT          -

                       DE          -

                       DC          -

       

      Country and State are dimension and Population is expression.

      Now when no sales for all the States, still I want to see pivot chart as above with value 0 for Sales, rather than shrinked.

       

      Is there any way. I appreciate your help

      Thanks