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:
- Click on the Edit button to enter the edit mode.
- Click on the Charts button on the asset panel, which is at the left-hand side of the screen, and find the Table chart.
- Click on the Table chart, and then drag and drop it into the empty space at the bottom-left side of the sheet:
- Click ...
