I want Top 5 fruits for 2016 and 2017 to be listed in the uploaded qvw. If Top 5 of both year is not possible then I want top 5 fruits by 2017
I tried using dimensions limit by making it straight table. But then when i try to move the Fiscal year to the top column by moving blue arrow I cant. So I used pivot table, but in pivot table the dimension limits go away.
I think I need to use aggr function with rank function, but not sure how.