Observe:

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

Capture.JPG

2. LOD Values

Capture2.JPG

Parameter LOD

Capture3.JPG

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.

 

http://public.tableau.com/static/images/De/DetroitCrime_1/CrimeMap/1.png