1) In the Data pane, right-click a dimension and select Aliases.

2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.

✑ To submit your changes: In Tableau Desktop, click OK.

On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.

When you add the field to the view, the alias names appear as labels in the view. For example:

Reference: https://help.tableau.com/current/pro/desktop/en-us/datafields_fieldproperties_aliases_ex1editing.htm

A union of these tables creates the following single table that contains all rows from all tables.

Reference: https://help.tableau.com/current/pro/desktop/en-us/union.htm

2) But, this isn’t all right? We need to focus on the year 2013.

This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:

2) But, this isn’t all right? We need to focus on the year 2013.

This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:

2) But, this isn’t all right? We need to focus on the year 2013.

This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:

2) Now, for sheet 2 – Drag nationality to the view, and gold to the size mark in the Marks shelf. NOTE: Depending on your version of Tableau, you may need to assign a Geographical role to the nationality column first as follows:

3) Now, let’s create a dashboard, and use both these sheets in it:

4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:

Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:

2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:

3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

Now the chart looks like this:

Now we change the Profit chart type to line:

5) Finally, we synchronise the axis as follows: Right click on the axis, and choose ‘Synchronise axis’

And, our final view and answer is:

2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:

3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:

We can see the answer already: 23.386% in the view above (even before grouping!)

4) Finally, we get the following view and our answer: