Learn Tableau by Working on Exciting Dashboards - Comparative Profit Analysis - Exclude LOD Example

The video tutorial explains how to use the exclude LOD expression in Tableau to create a benchmark for profit comparison. It demonstrates creating a calculated field for 2016 profit and using the exclude statement to apply this benchmark across different years. The tutorial also covers calculating the percentage difference in profit from the benchmark year, 2016, and formatting the results in Tableau.

How is the percentage difference from the benchmark year calculated?

What does the result indicate when comparing profits from 2017 to the benchmark year?

Summarize the overall findings from the profit analysis conducted in the tutorial.