2 Replies Latest reply: Jan 1, 2013 12:50 AM by Mohanraj Subramanian RSS

    Changing the pivot table values into percentage  values

    Mohanraj Subramanian

      Hi Guys,

                   I Have a Pivot table Of these columns.i have data's in values .

      CountryFemale male total
      Albania455297
      Algeria154542696
      American Samoa436481917
      Andorra284169

       

      As per Client requirements there should be a list box or button with 2 options like values and percentage.So they can view their data in which format they like .

      If we select percentage from list box The data should be in this format.

       

      CountryFemale male total
      Albania46.453.697
      Algeria22.177.9696
      American Samoa47.552.5917
      Andorra40.659.469

      Any Suggestion about this.

      Regards,

      Mohanraj Subramanian.