I need to Rank on Wk5 column and filter top 5 total, but want to display both WK 4 and WK5 for colA
WK4 and WK5 are coming from sameWeek column
Is this possible ? If Yes, how can we achieve it?
Hi @Praveena
Welcome to the QuickSight community!
In the Pivot Table visual you have Top or Bottom filter, that can help you achieve what you want.
Here’s an example screenshot where I am showing Top 2 Skills by the Count of assignments.
Regards,
Giri
@Giridhar.Prabhu , This works if we have only Wk5
But my requirement is want to pick top n on WK5 and need to show WK4 too
When I do top n, it is picking from both Wk5 and Wk4
Hi @Praveena
I don’t understand your point about when I select Top N it takes both WK5 and WK4. I guess the ranking is based on a field.
Can you provide some more details?
Regards,
Giri
Here WK4(week 4) and WK5(week 5) both are same dimension coming from week
We have 2 dimensions - ColA, Week and one measure - total here
Hi @Praveena
Can you try something like this?
rank([ifelse({week}= “WK5”, {total}, 0) DESC], )
Regards,
Giri