1 Reply Latest reply on Dec 31, 2016 11:27 AM by Jim Dehner

    Percentages Changing to Sums

    jeremy marcus

      In my data set, I have CAGR percentages already calculated for all of my countries. I want to keep this data as percentages, but every time I drag it to the Column part of my worksheet, the data automatically changes to "Sum". I can't figure out a way to keep the data as a percentage. I know how to calculate "percentage of" data, but that doesn't apply to my situation. Can someone please share with me how to keep my data as percentages / decimals?

       

      Thanks!