Cross Tab Filter

Example

This Chart Canvas chart includes:

Custom theme
Series.Area
Crosstab Filter, with Median value function
Legend Filtering (click Legend item to toggle)

<ChartCanvas ChartHeight="400" ChartWidth="750" ChartCaption="Area Chart with Crosstab Filtering" PlotBackgroundColor="AliceBlue" ID="Chart_Crosstab1" PlotBorderColor="#505050" PlotBorderThickness="1" IdeDisplayStatus="Collapsed">
  <Series Type="Area" ChartXDataColumn="tpcMonthName" ChartXDataColumnType="Text" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" ID="dlEmployees1XML" XMLFile="NW_Employees.xml" MaxRows="5" IdeDisplayStatus="Collapsed">
      <Join ID="joinInner" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
        <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" />
        <DataLayer Type="XMLFile" ID="dlOrders1XML" XMLFile="NW_Orders.xml" />
      </Join>
      <ConditionFilter Condition="Year(CXMLDate(&quot;&quot;)) &lt;= 2010" />
      <TimePeriodColumn DataColumn="OrderDate" ID="tpcMonthNo" TimePeriod="Month" />
      <TimePeriodColumn DataColumn="OrderDate" ID="tpcMonthName" TimePeriod="MonthName" />
      <SortFilter SortColumn="tpcMonthNo" DataType="Number" SortSequence="Ascending" />
      <CrosstabFilter CrosstabValueFunction="Median" CrosstabColumn="LastName" CrosstabValueColumn="Freight" CrosstabLabelColumn="tpcMonthName" />
    </DataLayer>
  </Series>
  <ChartCaptionStyle FontFamily="Segoe UI" FontSize="22" FontWeight="Normal" AlignmentHorizontal="Left" />
  <ChartXAxis AxisCaption="Month" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontFamily="Arial" FontSize="16" FontColor="#505050" />
    <AxisLabelStyle OffsetY="20" FontAngle="45" FontColor="Gray" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Weekly Sales Median" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontFamily="Arial" FontSize="16" FontColor="#505050" />
    <AxisLabelStyle Format="$###,###" FontColor="Gray" />
    <ChartTicksAndGrid />
  </ChartYAxis>
  <ChartCanvasLegend LegendOrientation="Vertical" OffsetY="43" LegendSymbolWidth="10" IdeDisplayStatus="Collapsed">
    <LegendLabelStyle FontColor="Gray" />
  </ChartCanvasLegend>
</ChartCanvas>

This Chart Canvas chart includes:

Custom theme
Series.Bar
Crosstab Filter, with Sum value function
Data, Label, and Caption formatting
Legend Filtering (click Legend item to toggle)

<ChartCanvas ChartHeight="400" ChartWidth="750" ChartCaption="...with Bar Series" PlotBorderColor="SaddleBrown" PlotBorderThickness="1" PlotBackgroundColor="Beige" PlotBackgroundColorTransparency="9" ID="Chart_Crosstab2" IdeDisplayStatus="Collapsed">
  <Series Type="Bar" ChartXDataColumn="tpcMonthAbbrev" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" ID="dlEmployees2XML" XMLFile="NW_Employees.xml" MaxRows="5" IdeDisplayStatus="Collapsed">
      <Join ID="joinInner" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
        <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" />
        <DataLayer Type="XMLFile" ID="dlOrders2XML" XMLFile="NW_Orders.xml" />
      </Join>
      <ConditionFilter Condition="Year(CXMLDate(&quot;&quot;)) &lt;= 2010" />
      <TimePeriodColumn DataColumn="OrderDate" ID="tpcMonthNo" TimePeriod="Month" />
      <TimePeriodColumn DataColumn="OrderDate" ID="tpcMonthAbbrev" TimePeriod="MonthAbbreviation" />
      <SortFilter SortColumn="tpcMonthNo" DataType="Number" SortSequence="Ascending" />
      <CrosstabFilter CrosstabValueFunction="Sum" CrosstabColumn="LastName" CrosstabValueColumn="Freight" CrosstabLabelColumn="tpcMonthAbbrev" />
    </DataLayer>
  </Series>
  <ChartCaptionStyle FontFamily="Arial" FontSize="28" FontWeight="Lighter" FontColor="LightCoral" />
  <ChartXAxis AxisCaption="Month" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontFamily="Arial" FontSize="16" FontColor="#505050" />
    <AxisLabelStyle OffsetY="20" />
    <ChartTicksAndGrid TickLineThickness="1" TickLineColor="Silver" TickmarkPlacement="Center" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Weekly Sales Total" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontFamily="Arial" FontSize="16" FontColor="#505050" />
    <AxisLabelStyle Format="$###,###" FontColor="Gray" />
    <ChartTicksAndGrid TickInterval="100" TickLineThickness="1" TickLineColor="Silver" />
  </ChartYAxis>
  <ChartCanvasLegend LegendOrientation="Vertical" OffsetY="43" BorderColor="SaddleBrown" BackgroundColor="Beige" BackgroundColorTransparency="9" BorderRadius="0" />
</ChartCanvas>

This Chart Canvas chart includes:

Custom theme
Series.Line
Crosstab Filter, with Average value function
Data, Label, and Caption formatting
Legend Filtering (click Legend item to toggle)

<ChartCanvas ChartHeight="400" ChartWidth="750" ChartCaption="...with Line Series" PlotBackgroundColor="BurlyWood" PlotBackgroundColorTransparency="9" ID="Chart_Crosstab3" IdeDisplayStatus="Collapsed">
  <Series Type="Line" ChartXDataColumn="tpcMonthAbbrev" IdeDisplayStatus="Collapsed">
    <DataLayer Type="XMLFile" ID="dlEmployees3XML" XMLFile="NW_Employees.xml" MaxRows="5" IdeDisplayStatus="Collapsed">
      <Join ID="joinInner" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
        <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" />
        <DataLayer Type="XMLFile" ID="dlOrders3XML" XMLFile="NW_Orders.xml" />
      </Join>
      <ConditionFilter Condition="Year(CXMLDate(&quot;&quot;)) &lt;= 2010" />
      <TimePeriodColumn DataColumn="OrderDate" ID="tpcMonthNo" TimePeriod="Month" />
      <TimePeriodColumn DataColumn="OrderDate" ID="tpcMonthName" TimePeriod="MonthName" />
      <SortFilter SortColumn="tpcMonthNo" DataType="Number" SortSequence="Ascending" />
      <CrosstabFilter CrosstabValueFunction="Average" CrosstabColumn="LastName" CrosstabValueColumn="Freight" CrosstabLabelColumn="tpcMonthName" />
    </DataLayer>
  </Series>
  <ChartCaptionStyle FontFamily="Calibri" FontSize="28" AlignmentHorizontal="Center" />
  <ChartXAxis AxisCaption="Month" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontFamily="Arial" FontSize="16" FontColor="#505050" />
    <AxisLabelStyle OffsetY="20" />
    <ChartTicksAndGrid TickmarkPlacement="Center" GridLineThickness="0" />
  </ChartXAxis>
  <ChartYAxis AxisCaption="Weekly Sales Average" ScaleLowerBound="0" ScaleUpperBound="350" IdeDisplayStatus="Collapsed">
    <AxisCaptionStyle FontFamily="Arial" FontSize="16" FontColor="#505050" />
    <AxisLabelStyle Format="$###,###" FontColor="Gray" />
    <ChartTicksAndGrid TickInterval="50" GridLineColor="#7ABABA" GridLineThickness="1" />
  </ChartYAxis>
</ChartCanvas>