Configuring a Series

You can select Series in the Chart Axis column for any Data Source Columns. The data source column should have Axis dimension assigned to it.

You can display a series only on chart view, which means the pivot grid can only have a display of Chart or Pivot Grid and Chart.

In this example Month is defined as a Series. All the axes columns have All (Total) enabled. The total field is available on the Specify Data Model Values page.

In the Pivot Grid Viewer you can see the model with months as series.

The chart shows Month as series.

You can also drill down using the X axis. Right click and select Drilldown Intersection To. The option enables you to drill down to a datapoint in X axis, in this example you can drill down to product information for the selected month.

This example shows the chart with Products selected from the Drilldown Intersection To options.

This example shows the grid and chart with detailed data based on the Month field.