top of page

Tableau: How to Use the Same Measure at Different Levels of Aggregation in the Same View

Step 1:

Drag sum(sales) onto the label mark.

Step 2:

Drag another sum(sales) to the detail mark. Change the aggregation to average instead of sum.

Step 3:

Drag the average pill into the middle of the view to show measure names and measure values.