21 Replies Latest reply: Dec 22, 2017 7:39 AM by Sunny Talwar RSS

    Linechart show Top 2 based on an other (!) Keyfigure

    Oliver Franz

      Hi There,

       

      My data looks like this:

       

      Customer, Month, Value1, Value2

      A,1,15,1

      A,2,20,1

      A,3,24,1

      B,1,12,2

      B,2,15,2

      B,3,16,2

      C,1,9,2

      C,2,8,2

      C,3,7,2

       

      This data changes from time to time.

       

      My goal is to show a linechart with the Dimension Customer and Month and the Keyfigure Value1. But I only want to show the top 2 customers based on Value2.

       

      In my example the linechart should only show Customer B and C as the have the biggest Values for Value2.

       

      I tried to create a dynamic dimension using if and rank, but this did not work as expected.

       

      Do you have any idead how to solve this?

       

      Thanks for your help!