Here, we will learn how to create a dynamic measure in a table visualization using a condition to show the average price in the total heading and the sales amount for each category.

We will add the visualization, Table chart with dimension Category, and measure Sales $.

Follow these steps to create the visualizations:

1. Click on the Edit button to enter the edit mode.
2. Click on the Charts button on the asset panel, which is at the left-hand side of the screen, and find the Table chart.
3. Click on the Table chart, and then drag and drop it into the empty space at the bottom-left side of the sheet:

4. Click on Add dimension and select Category in the Dimensions section.
5. Click on Add Measure and select Sales $ in the Measures section.
6. Click on the chain icon in the measure to unlink from the master measure and unlock the expression editor:

7. Click on the fx button to open the expression editor, then type the following expression: if(rowno()=0,sum(SalesAmount)/sum(Quantity),sum(SalesAmount)).
8. Click on the Apply button to close the expression editor and save the expression.
9. Fix the measure Number formatting to show the number with two decimal places.
10. Resize the width of the table to fit ten columns of the grid. The Table chart will look like this:

11. Go to the properties panel.
12. Click on the Appearance heading and then the General section to expand it.
13. Switch on the Show titles property and type Sales by Category and Total Average Price.
14. Click on the Presentation section to expand it.
15. In the Totals labels property, type Total Average Price. The Table chart will look like this:

The sheet now looks like the following screenshot:

We learned how to create a different calculation condition for the total heading of the table. This calculation shows the average price of the products sold for the current selection.