Using the Pivot Table to refine the application data

You can use the Pivot Table dimension values to refine the application data.

If a dimension allows refinement, then when you click the dimension values in the row and column headings, the data is refined by that value.

When you click a metric value, then the data is refined by all of the dimension values that apply to that cell and that allow refinement.

So for example, if a cell displays an average price of $25.55 for Red wines in the Bordeaux region for the year 1992, then when you click the value $25.55, the data is refined by the values: