When the parameter is set to State all the LOD values across the sate remains same (even if the report is drilled to city) across Category and Segment

When Category is selected, the LOD values are constant for each of the columnar Category for all States and Segments

When Segment is selected, the Colored Segments same across all states and Categories


Two Calculated Fields and a Parameter

1. LOD Avg Sales


2. LOD Values


Parameter LOD


The drop-down Parameter LOD controls the calculated fields LOD Values and the LOD Avg Sales based on the choice made by the user.

Interact with the report embedded to Tableau Public.