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