2 Replies Latest reply on Mar 16, 2017 2:41 PM by Patrick A Van Der Hyde

    Automatic calculation: difference to Top 3 of a peer group

    robert.linz

      Hi all,

       

      I have a list of values of a peer Group for each quarter (attached screenshot).

       

      I want to calculate the difference between "1" of "Konzern" and the Top3 of the peer group (in this case "8", "6" and "4").

       

      I need an automatic calculation of the difference, because the Top3 of the peer group could change every quarter.

       

      The results (difference "1" to TOP3, ... to TOP2, ... to TOP1) should be shown separately.

       

      I hope you can understand my problem.

       

      Thanks in advance, Robert