1 Reply Latest reply on Mar 28, 2018 2:14 PM by Wes Reneau

    Percentage Column

    Siddharth Sharma

      I want to add a percentage column for each year and then add another column at the end taking the difference of the percentages.

       

        • 1. Re: Percentage Column
          Wes Reneau

          Hi Siddharth,

           

          I believe you can accomplish what you're describing with a Quick Table Calculation. For the attached example, I added the Sales measure and then clicked on the drop down arrow while hovering over the measure in the Measures Value area. I selected Quick Table Calculation > Percent of Total and then selected Compute Using = Table (across).

           

          You'll probably need a Calculated Field to calculate the difference of percentages, but this is as far as i can help without a sample workbook.

           

           

          -W