Exclude LOD -Tableau

Question

How to show a region's data over a country data by LOD expression without using filter?

Answer 1

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