Using the Pivot Table to refine the project data

You can use the Pivot Table dimension values to refine the project 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:
  • Red for the Wine Type attribute
  • Bordeaux for the Region attribute
  • 1992 for the Vintage attribute

For more details on refining by data on a component, see Using a component to refine data.