<ChartCanvas ChartCaption="Basic Heatmap" ChartHeight="500" ChartWidth="800">
  <Series HeatmapColorDataColumn="avgOrderValue" HeatmapLabelDataColumn="ProductName" HeatmapSizeDataColumn="avgOrderValue" Type="Heatmap" IdeDisplayStatus="Collapsed">
    <DataLayer ID="dlHeatMapData1XML" Type="XMLFile" XMLFile="NW_Categories.xml" IdeDisplayStatus="Collapsed">
      <Join ID="joinInner" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
        <MatchCondition LeftDataColumn="CategoryID" RightDataColumn="CategoryID" />
        <DataLayer ID="dlProductsXML" Type="XMLFile" XMLFile="NW_Products.xml" IdeDisplayStatus="Collapsed">
          <Join ID="joinInner2" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
            <MatchCondition LeftDataColumn="ProductID" RightDataColumn="ProductID" />
            <DataLayer ID="dlOrderDetailsXML" Type="XMLFile" XMLFile="NW_OrderDetails.xml" IdeDisplayStatus="Collapsed">
              <Join ID="joinInner3" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
                <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" />
                <DataLayer ID="dlOrdersXML" Type="XMLFile" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
                  <Join ID="joinInner4" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
                    <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" />
                    <DataLayer ID="dlEmployeesXML" Type="XMLFile" XMLFile="NW_Employees.xml" />
                  </Join>
                </DataLayer>
              </Join>
            </DataLayer>
          </Join>
        </DataLayer>
      </Join>
      <CalculatedColumn Formula=" * " ID="calcOrderValue" />
      <GroupFilter DataType="Text" GroupColumn="CategoryID" Hierarchical="False" ID="grpCatID" KeepGroupedRows="True">
        <GroupFilter DataType="Text" GroupColumn="ProductID" Hierarchical="False" IncludeCondition="grpProdID1" KeepGroupedRows="False">
          <GroupAggregateColumn AggregateColumn="calcOrderValue" AggregateFunction="AVG" DataType="Number" ID="avgOrderValue" />
        </GroupFilter>
      </GroupFilter>
    </DataLayer>
    <Action ID="actReport" Type="Report" IdeDisplayStatus="Collapsed">
      <Target Report="DrillDownTarget" Type="Report" />
      <LinkParams PassedData="@Chart.ProductName~" />
    </Action>
  </Series>
  <ChartCaptionStyle AlignmentHorizontal="Left" />
</ChartCanvas>