6 Replies Latest reply on Jul 16, 2018 8:43 AM by Chitra P

# Calculated Column

Hi,

Can we create a user filter/parameter with three values like International, Domestic and All for a field 'Address'  and 'Country' from Dimension?

Y axis - Gross Square Foot

The default bar chart should display all the countries(Top 10 based on square feet). The user should have a parameter where they have the option to filter all US (Top 10 Domestic), Non-US(Top 10 International) and All (Top 10 All countries, default view).

As I'm new to Tableau, appreciate if you could attach your worksheet along with explanation.

I'm using Tableau 10.5.

Thank you.

• ###### 1. Re: Calculated Column

Hi, Chitra

Hope this helps

ZZ

• ###### 2. Re: Calculated Column

Thank you Zhang, this is what I'm looking for.

Quick question, How did you create a new field(F4) in Dimensions? Could you please explain why do we need a filter with True Value?

-Chitra.

• ###### 3. Re: Calculated Column

Hi, Chitra

to your question, I don't create new field F4, it exists in your original workbook.

In terms of filter, if you look at the calculation logic, it excludes the data based on different selection of parameter value, the reason why it has to been added into context is, when you use top N in the filter, it calculates across the whole data set unless you add your filter into context so it will take effect before the top N being processed.

Hope this make sense.

ZZ

• ###### 4. Re: Calculated Column

Hi Zhang,

When you select USA, it still shows the international location. If you see the 11th value it points to India location when USA is selected from the filter.

• ###### 5. Re: Calculated Column

Hi, Chitra

Can you provide the workbook? and which field you drag to your detail to display the INDIA label?

ZZ

• ###### 6. Re: Calculated Column

Hi Zhang, I've dragged the country field on the bars which displayed the India on one of the Bar as that points to India address. If you scroll up to my question, I've attached the worksheet as Top N Building 1.

-Chitra.