4 Replies Latest reply on Nov 9, 2016 5:22 AM by Hima vardhan Reddy Pavuluri

# Show Top 10 country list without impacting all value

Hi

I am new with parameters and I can't seem to find a solution for the following task

--> I have the chart below & I want to be able to show a special list that proposes:

-the top 10 states based on sales (because total list is too long + I want to follow only big ones not minor ones).

-all states (but including also those not part of top 10 states to not impact my total sales)

Any tips?

Thanks a lot!

Regards

Leslie

• ###### 1. Re: Show Top 10 country list without impacting all value

Sorry.

I don't have Tableau 10. I didn't understand the relation between this picture(category) and States.

I didn't understand what you want to see. Are two different views? They seems to conflict to me.

• ###### 2. Re: Show Top 10 country list without impacting all value

I want to be able to change view on a specific state if I want to (based on top 10 states) or have all values shown.

In my view and FILE if you check on state filter you will see the list is too long and I would want list to show only 10 top states (based on sales)

Is that more clear?

Regards

• ###### 3. Re: Show Top 10 country list without impacting all value

Hi.

Create a Set of States like this:

Drag on filter cards and set to show in/out values.

Doing it, you will be able of show all values or in option.

• ###### 4. Re: Show Top 10 country list without impacting all value

Find My approach like below :

Create a parameter with 2 values Top 10,All to choose which way we want out filter to be.

Then create a set for Top 10 list :

Create a calculation like below : I named it Filter .

IF [Select]='Top 10' THEN (IF [Top 10 State set] THEN [State] END)

ELSE [State]

END

Then just duplicate this calculation and drag Filter(copy) into filters shelf and exclude Null.

Then drag Filter into Filters shelf and choose show quick filter and in filter option choose to show only relevant values.

This step is to remove Null value from filter when we choose Top 10.

Attached workbook for Reference.

2 of 2 people found this helpful