1 Reply Latest reply on Aug 15, 2013 4:14 PM by Pedro Machado

    % Difference calculation

    chaitanya.ragu.0

      Want to Calculate the % difference  between one client_3  to Client_1, Client2, Client 4, Client5.

       

      Client    Median(Measure)  %Difference(Client 3) compared to all other clients

      Client1      14.5                 %(22 - 14.5)  and color code according to requirement

      Client2       31                    %(22-31)

      Client3       22

      Client4       11                    %(22-11)

      Client5        12                    %(22-12)

       

       

      Please help me the formula I have to use to get the %diff values.

        • 1. Re: % Difference calculation
          Pedro Machado

          Please post a packaged workbook with some sample data and the visualization as close as you can to what you want. It's important to tell us how Client 3 is selected to be the benchmark. For example, the "benchmark" customer is the top customer by X measure or the "benchmark" customer must be selected by the user.

           

          Pedro