Exclude LOD -Tableau

0 votes
How to show a region's data over a country data by LOD expression without using filter?
Apr 2 in Tableau by nikki
11 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,

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 by CHERUKURI
• 13,940 points

Related Questions In Tableau

0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
945 views
+2 votes
1 answer
0 votes
0 answers

How to export the IdP (Identity provider) XML Metadata from Keycloak which is imported to Tableau?

Keycloak version 1.6.1, Goal: Keycloak should act ...READ MORE

Mar 28, 2018 in Tableau by Atul
• 5,470 points
263 views
0 votes
1 answer

Tableau Vs Qlikview

Tableau is mostly used as a reporting ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points

edited Mar 29, 2018 by QueenBee 9 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,200 points
44 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
290 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

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

INCLUDE LOD- tableau

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

answered Apr 2 in Tableau by CHERUKURI
• 13,940 points
9 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 in Tableau by CHERUKURI
• 13,940 points
12 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.