giannzi Member

I wish I can also filter the columns in the preview mode.

Hello @ggenovese, When I add the Academic Plan into my fixed function partition, it would only give me one Term/semester because only the last Term have the Academic plan of bachelor's degree. The rest Terms have null Academic Plan. I tried doing this but it still gives me the same result as above. Do you have any other…

@ggenovese Oh nevermind! I found my mistake. I didn't add the ROW_NUMBER function. It's now good! THANK YOU!

@ggenovese Thank you for your solution. I tried doing it but when I add the Filter tile, it says that my source is not valid. Do you know how can I fix this? Thank you!

@GrantSmith Thank you! I saw that I have a duplicate key column.

@DavidChurchman I didn't see that. Thank you!

@ColemenWilson Thank you so much!

Hi @ColemenWilson , thank you for your answer. When I did it, there were 2 columns: Country and Country2. Is it possible to only have 1 column: the Country?

Hello @GrantSmith, in this case, based on 2019 data please. But if I can know the way to base it on 2024, that would be great.