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

[Oliver_F]

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!

[Oliver_F]

Hey Sunny,

a thousand thanks for your help! This indeed looks pretty good. I will now have to figure out if and how this will work with my actual data that needs much more complex calculations.

Once again thank you very much for your input.

[sunny_talwar]

Awesome, I am glad we were able to get a break through