1 of 1 people found this helpful
Want to show default rank when you access filter.
LOOKUP(attr([Category]),0) and drag to filter.
un select furniture and remaining are same rank now.
Just saw this discussion, How do you show overall ranking after selecting x?
closing this discussion.
And Sankarmagesh Rajan your solution is what i was looking so, marking your response as correct. Thanks
Hey, I have two sheets, one is which I created based on above response.
and there is on another worksheet.(see below)
but There is no option to apply this filter on selected sheet on the new field ewhich we had created using LOOKUP(attr([Category]),0)
Dashboard 1.twbx 1.1 MB
to bring this to the top of the forums.