One of other keyword of LoD is the function EXCLUDE. If you have already read my article about INCLUDE than you will easier understand the function EXCLUDE. Remember! By the function INCLUDE we included some numbers into the calculation even though we didn't visualize this number. By the function EXCLUDE we exclude some numbers from the calculation even through we visualize them. However, let's us go step by step... With the function EXCLUDE you can find answers to such questions like: - What is the total slaes, as well as the total sales by region. Its means: [(1) We need to exclude Region from our calculation of the monthly Total Sales (2) And then include Region when calculating the regional Sales breakdowns.] Here is the structure of this function: With other words: with this formula we said to Tableau: "Hey, Tableau, please ignore (EXCLUDE) "Region" if you calculate sales (SUM[Sales])" Let's have a look to the practice:...