In this example, we are going to look at** two different ways to get the same result** in Tableau.

*Follow along using Tableau’s Superstore dataset. *

Look at the screenshot above. It’s the final result that we want to achieve.

We want to compare the profit of each Sub-Category to the one of the Sub-Category selected by the **Parameter** on the right.

As you can see,** the value for Appliances is 0 in the view**. This is because the profit for each Sub-Category is compared to that one.

## Steps:

- Let’s right-click on the Sub-Category dimension and create a parameter called
**Choose a Sub-Category**.

Then click on **Show Parameter Control**.

Now we want to look at the Accessories’ profit (the first item under Sub-Category) and compare it to the Envelopes’ profit, which we have selected in the Parameter, and we want to repeat this process for all the other items.

Therefore, we first need to calculate the Envelopes’ profit, which we don’t know.

The LOD below allows you to **bring back the total profit for the Sub-Category selected** through the Parameter **Choose a Sub-Category**.

Notice how the LOD isn’t fixed on any dimension.

In this case, **{FIXED** or **{** not followed by anything would mean the same thing.

Now that we have assigned a value for the selected Sub-Category, we can **calculate the difference between the SUM(Profit) of each Sub-Category and the one of the Sub-Category we have selected via the parameter**.

To do that, we calculate the difference between the SUM(Profit) and the LOD calculation. I have called this calculated field **Difference between sub-categories.**

Drag **Sub-Category** onto **Rows** and this calculated field both onto **Columns** and the **Color Shelf **and you will be able to see how the profit of all the Sub-Categories compare to that of Appliances.

## Are LODs the only way to solve it? Actually, no. Let’s try using Table Calcs

**Since we have all the fields in the view, we can replace LODs with Table Calcs.**

Again, let’s drag **Sub-Category** onto **Rows** and **SUM(Profit)** onto both **Columns** and the** Color shelf.**

Now we want to add a **Table Calculation to calculate the difference. **

Let’s right-click on SUM(Profit), select **Quick Table Calculation **and then **Difference**.

However, we still need to** configure the Table Calculation correctly. **

Click on **Edit Table Calculation**. Compute using **Specific Dimensions** and check **Sub-Category. **

This time, we need to compute the difference **relative to the parameter. **Select **Choose the Sub-Category parameter **from the drop-down.

You have now have obtained the same chart as above, but without using LODs.

## Trackbacks/Pingbacks