2 of 2 people found this helpful
Here's an example using Sample Superstore. In this example, States ~ Employers, Sub-Category ~ Job Title, and Avg Sales ~ Avg Salary. The index field in here was just a way of me checking my work while I was testing things out, but it can be removed .
I created the Top N States parameter and showed the control on the sheet:
I put State on Columns and Avg Sales on Rows.
I put Sub-Category in the Filter shelf, and clicked Add to Context, and Show Filter.
I put State in the Filter shelf, and in the General tab, selected "Use all".
Then (still in the State Filter dialog box), I went to the "Top" tab:
Click Ok. And you're all set. The user can choose the Top N number in the parameter slider, and choose the Sub-Category in the filter:
Workbook is attached. I hope this helps!
Hi Hari ,Many thanks for Help .. Let me try your solution ,Will keep you posted on it . Appreciate you taking time out.
Hello Jennifer ,
Thanks for detailed snippet of the steps . I will check and apply this along with hair's approach and let you know results .
Appreciate you taking time out.
The solution works for the attached sheet ,Did same think and no results were shown when searched ..not sure why . I got however got it worked with SOlution posted above .Many thanks for taking time out to help on this . It helped me learn something new