Need Rank filter

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

Hi @Praveena

Can you please try using the rank function.

Example:

rank([WK5 DESC], [])

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