Tableau | Fixed Calculation

+--------------------------------------------------------------------------+ | LOD TYPES | +---------------------------------+----------------------------------------+ | FIXED | Ignores dimensions in the view. | | | Locks to specified dimensions. | +---------------------------------+----------------------------------------+ | INCLUDE | Computes at the view level plus | | | specified dimensions. | +---------------------------------+----------------------------------------+ | EXCLUDE | Computes at the view level minus | | | specified dimensions. | +---------------------------------+----------------------------------------+ How FIXED Interacts with Tableau Filters

FIXED : SUM(Sales)

Create the Boolean Flag.

: You might want to calculate the total sales for each year and then compare it year over year. A FIXED calculation can help you compute the total sales per year once, and then you can easily compare across years. fixed calculation tableau

If you just count Customer Name by Month of Order Date , you are counting transactions , not unique customers. Worse, if someone bought in Jan and Feb, they appear in both months. A FIXED calculation can help you compute the