Swapping rows and columns

Sometimes the data points are located in undesirable locations, which makes looking at the numbers slightly challenging. By swapping rows with columns, we can offer a different point of view to the reader.

Getting ready

For this recipe, let's use the same sample file, Sample – Superstore Sales (Excel). Open a new worksheet and select Sample – Superstore Sales (Excel) as the data source.

How to do it...

Once the data is loaded, we will follow the steps from the previous recipe to reproduce the scatter plot and then swap the rows with columns using the following steps:

  1. From the top toolbar, under Analysis, uncheck Aggregate Measures.
  2. Drag-and-drop Profit into the Columns shelf.
  3. Drag-and-drop Sales into the Rows shelf.
  4. Click on the swap button to place Sales in the Columns shelf and Profit in the Rows shelf. The swap button is shown in the following screenshot:
    How to do it...

How it works...

Swapping of rows with columns and columns with rows works with almost any type of chart and it is a very useful tool when we want to quickly change the orientation or position of the visualization. Tableau makes it very easy to make such a change.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset