2 Replies Latest reply on Apr 24, 2016 12:46 AM by Tam Nguyen

Action Filter on a Top N Worksheet where Top N is a Parameter

Tam Nguyen Apr 22, 2016 5:18 PM

Hello,

I've a question on using action filter on a top N worksheet where top N is a parameter. I was able to do this only if the second worksheet is a top 10 where top 10 is a fixed number. The question is how to add a top N parameter and make it work. Attached is the sample workbook.

Thanks

Tam Nguyen

Action filter on top N worksheet.twbx 1.3 MB

1. Re: Action Filter on a Top N Worksheet where Top N is a Parameter

Simon Runc Apr 23, 2016 2:39 AM (in response to Tam Nguyen)
hi Tam,

Here you go...you were 99% there!

I added the following calculated field
[Top N Filter]
[rank]<=[Parameters].[Top N Customers]

and then brought this onto the filter shelf and set to true (with the compute using advanced, with sort, as you had for your [rank] measure.

Action filter on top N worksheet - SR.twbx 485.0 KB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: Action Filter on a Top N Worksheet where Top N is a Parameter

Tam Nguyen Apr 24, 2016 12:46 AM (in response to Simon Runc)

Thank you Simon for your solution!
Like Show 1 Likes(1)

Actions

Go to original post

Tableau Community

Action Filter on a Top N Worksheet where Top N is a Parameter

1. Re: Action Filter on a Top N Worksheet where Top N is a Parameter

2. Re: Action Filter on a Top N Worksheet where Top N is a Parameter

Actions

More Like This