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
15 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 13,860 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,470 points
363 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
13 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,470 points
58 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
286 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
22 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,470 points
21 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,200 points
219 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
• 13,860 points
51 views
0 votes
1 answer

How to sort by any measure in a Tableau table?

Hi Sindhu, Once you have created a bar ...READ MORE

answered Mar 8 in Tableau by CHERUKURI
• 13,860 points
64 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.