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, 2019 in Tableau by nikki
263 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, 2019 by Cherukuri
• 32,460 points

Related Questions In Tableau

0 votes
1 answer
0 votes
1 answer

Is it possible to create a hierarchy drill down using pie charts in Tableau

Hey Gowri, Regarding your doubt, you can go ...READ MORE

answered Feb 17 in Tableau by Gitika
• 31,310 points
292 views
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
1,196 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,820 points
75 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,820 points
1,622 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,820 points
145 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
123 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
2,135 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, 2019 in Tableau by Cherukuri
• 32,460 points
2,334 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, 2019 in Tableau by anonymous
• 32,460 points
81 views