Tableau: Creating Interactive Data Visualizations

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 ...