LOD expressions- Create a calculation that is not affected by filters.

0 votes
I want to view the sales of a country vs its region and all countries and sales. I have added a filter for country to compare country and region wise sales.

I added a lod like this { FIXED [Country] : SUM([Sales]) }

But wrong values are shown for it. Can someone help me?
Apr 2 in Tableau by nikki
35 views

1 answer to this question.

0 votes
Hi Nikki,

Your LOD expression is correct, but the filter does not affect your field (from LOD expression).
Thus what you have to do is to convert the filter to context filter.

To convert to context filter, Right click on the filter field and click on add to context.
Thus the filter would be sensitive to created through LOD expression.
For suppose, if you want to show country sales wrt all selected from filter from same region, then convert filter to context.
You would observe the difference, that the total changes from after and before adding to context.
Hope this helps you.
answered Apr 2 by Cherukuri
• 25,580 points

Related Questions In Tableau

0 votes
1 answer
0 votes
1 answer

How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE

answered Apr 2, 2018 in Tableau by Atul
• 5,530 points
598 views
0 votes
1 answer

Not showing a dual axis

On the Rows shelf, right-click on the ...READ MORE

answered Apr 10, 2018 in Tableau by QueenBee
• 1,810 points
33 views
0 votes
1 answer

Creating a calculated field with LOD expression

Go ahead and try the following three ...READ MORE

answered Apr 20, 2018 in Tableau by Atul
• 5,530 points
92 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
574 views
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

answered Apr 12, 2018 in Tableau by QueenBee
• 1,810 points
48 views
0 votes
1 answer

How can I create a second sheet which is filtered to 8 days ago,

Following are the steps you can follow: Create ...READ MORE

answered Jul 11, 2018 in Tableau by Atul
• 5,530 points
38 views
0 votes
1 answer

How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
664 views
0 votes
1 answer

In Tableau, how to pass measure/dimension to action filters that are not in the chart?

Hi Sindhu,  You can choose the fields that are ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 25,580 points
579 views
0 votes
1 answer

What is pivot in Tableau? how to create a pivot?

HI, When the data required is present in ...READ MORE

answered Jun 12 in Tableau by anonymous
• 25,580 points
26 views