Calculate top 2 items based on a condition ( when entity exists in all the selected years)

[AnthonyJoseph]

 Hello Community,

I have a table where I have value of few entities. The ask is to display the top 2 items in a bar chart based on the years selected and only when entities are present in all the selected years.

For example: The data table looks like below:

and when the years 2019 and 2020 are selected, the expected result is as below:

Similarly when years 2021 and 2022 are selected, the below output is expected.

Please can someone help me in getting this sorted.

Thanks,

AnthonyJoseph

[FreemanZ]

hi @AnthonyJoseph 

when the years 2019 and 2020 are selected, wht only India stands out?

[AnthonyJoseph]

@FreemanZ  Because only India has value in both the selected years (2019 and 2020).