Step 1 - Create a worksheet Filter List as the cutomized quick filter list

1. Create a worksheet and rename it Filter List
2. Add Sub-Category to Rows, right click it, uncheck Show Header
   • 
3. Right-click Sub-Category, select Sort..., and configure the sort as follows:
   1. Sort By: Field
   2. Sort Order: Descending
   3. Field Name: Sales
   4. Affrefation: Sum
4. Add Sub-Category to Text in the Marks card
5. From the menu bar, select Format > Shading...
6. Change the Band Size of Row Banding to the leftmost level
   • 
7. Create the following calculation field Color: 

   if sum([Profit])<0 then "Red" else "Black" END

    

8. Add Color to Color on the Marks card
9. Edit the color lengend to set the colors
10. Click Tooltip on the Marks card, uncheck all options below:
    • Show tooltips
    • Include command buttons
    • Allow selection by category
    • 

Step 2 - Create a worksheet Button to show selected sub-categories of a filter

1. Create a worksheet and rename it Button
2. Create the calculation field 1 with "1" as the formula. (This field is used to initialize the filter action Button introduced below)
3. Create the following calculation field Button: 

   if countd([Sub-Category])=min({fixed:countd([Sub-Category])}) then "(All)"
   elseif countd([Sub-Category])>1 then "(Multiple values)"
   else min([Sub-Category]) end

4. Add 1 to Detail, Button to Text in the Marks card.
5. Click Tooltip in the Marks card and uncheck all options below:
   1. Show tooltips
   2. Include command buttons
   3. Allow selection by category

Step 3 - Build the dashboard

1. Create a dashboard and rename it Solutions
2. Place the views as follows:
   1. Target View on the left side of the dashboard
   2. Button above and to the right
   3. Filter List below the Button
3. Right click Button, uncheck Title, and change the view to Entire View
   • 
4. Right click Filter List, uncheck Title, change the view to Fit Width
5. Adjust all three worksheets to make the dashboard layout look natural.

Step 4 - Add dashboard actions

1. From the menu bar, select Dashboard > Actions...
2. From the pop-up window, select Add Action >Filter, create a filter action as the following:
   • Name: Button
   • Source Sheets: Button
   • Target Sheets: FIlter List
   • Run action on: Select
   • Clearing the selection will: Exculde all values
   • Filter: Selected fields
     1. Source Field: 1
     2. Target Field: 1
   • 
3. Repeat the above 2 steps to create a new filter action as the following:
   • Name: Filter
   • Source Sheets: Filter List
   • Target Sheets: Target View
   • Run action on: Select
   • Clearing the selection will: Keep filtered values
   • Filter: Selected fields
     1. Source Field: Sub-Category
     2. Target Field: Sub-Category
   • 

Step 5 - Verify functionality

1. Confirm the Button worksheet shows (All) and all sub-categories are visible in Filter List.
2. Click (All) in Button worksheet
3. Click Art in Filter List and confirm only Art is shown in the Target View
4. Confirm (All) is still displayed in the Button worksheet.
5. Go to Target View, right-click the generated filter Action(Sub-Category) in the Filters card, and select Apply to Worksheets > Selected Worksheets... 
6. Check worksheet Button in the pop-up window.
7. Go back to dashboard Solutions, confirm Art is still displayed in the Button worksheet now.
8. Click Art in Button worksheet, confirm the filter list is hiden.
9. Click Art in Button worksheet, select multiple sub-categories in the filter list sheet, confirm it displays (Multiple values) in the button sheet.