Exclude LOD -Tableau

0 votes
How to show a region's data over a country data by LOD expression without using filter?
Apr 2, 2019 in Tableau by nikki
354 views

1 answer to this question.

0 votes

Hi Nikki,

You can try this, 

{ EXCLUDE : SUM([Calculation1])-SUM([Sales]) } to get the sales except that country of all in that region

where Calculation1 is { FIXED [Region] : SUM([Sales]) }

you can view here, for more information

https://community.tableau.com/thread/253597

answered Apr 2, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

Tableau - What would the LOD calculation be?

Based on your requirements, I don't feel ...READ MORE

answered Mar 3, 2022 in Tableau by Vaani
• 7,020 points
396 views
0 votes
1 answer

Tableau - Conditions on LOD Expression

You can use LODing on both uid ...READ MORE

answered Mar 16, 2022 in Tableau by Vaani
• 7,020 points
1,686 views
0 votes
0 answers

Tableau - Bins based on Fixed LOD Customer Units

What I'm attempting to do is create ...READ MORE

Mar 25, 2022 in Tableau by Neha
• 9,060 points
320 views
0 votes
1 answer

How to exclude weekend (Sunday only) to DATEDIFF in Tableau?

To exclude Sundays from the DATEDIFF calculation ...READ MORE

answered Jul 3, 2023 in Tableau by anonymous
• 1,180 points
511 views
+1 vote
1 answer

Adding filter to LOD Expression

{ FIXED [Product]:COUNT(IF [Status]=0 THEN [Status] END)} Edit---- ...READ MORE

answered Aug 1, 2018 in Tableau by Atul
• 10,240 points
780 views
0 votes
1 answer

Reset filters in Tableau

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

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
3,699 views
0 votes
1 answer

How to create a global filter

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

answered Apr 13, 2018 in Tableau by QueenBee
• 1,820 points
1,177 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 ffdfd
• 5,550 points
865 views
0 votes
1 answer

INCLUDE LOD- tableau

Hi Anitha, you can add a calculation like ...READ MORE

answered Apr 2, 2019 in Tableau by Cherukuri
• 33,030 points
379 views
0 votes
1 answer

Compare grand average with individual average using Exclude LOD

Hi Anitha, Follow below steps: 1. Create a calculated ...READ MORE

answered Apr 17, 2019 in Tableau by Cherukuri
• 33,030 points
672 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP