Crosstab Table

Example
Basic Crosstab Table
Employee Name
2010
2011
2012
Sum
Average
# Orders
Buchanan, Steven$17,667.20 $31,433.19 $19,691.90 $68,792.29
$22,930.7642
Callahan, Laura$19,160.70 $56,954.04 $47,727.95 $123,842.69
$41,280.90100
Davolio, Nancy$30,861.76 $95,850.40 $60,565.22 $187,277.38
$62,425.79120
Dodsworth, Anne$9,894.52 $24,412.89 $42,142.66 $76,450.07
$25,483.3642
Fuller, Andrew$17,811.46 $71,168.14 $73,790.18 $162,769.78
$54,256.5993
King, Robert$15,232.16 $59,827.19 $44,559.89 $119,619.24
$39,873.0869
Leverling, Janet$18,223.96 $103,719.08 $80,869.80 $202,812.84
$67,604.28127
Peacock, Margaret$49,945.12 $124,655.57 $51,163.01 $225,763.70
$75,254.57151
Suyama, Michael$14,519.69 $40,826.37 $17,181.58 $72,527.64
$24,175.8865
Totals: $193,316.57$608,846.87$437,692.19$1,239,855.6345.9k809

  This Crosstab Table element includes:

  • Custom theme
  • Minimal attribute settings
  • Draggable columns (drag to rearrange)
  • Sum, Average & Count columns
  • Summary Row

<CrosstabTable ID="XTab1Basic" AjaxPaging="True" DraggableColumns="True" RememberSort="True" Width="800" WidthScale="px" Caption="Basic Crosstab Table" CaptionClass="ThemeTextLarger, ThemeMarginLarge" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrders1XML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <ConditionFilter Condition="CXMLDate(&quot;&quot;) &lt;&gt; &quot;&quot;" />
    <Join ID="joinInner1" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" />
      <DataLayer Type="XMLFile" ID="dlOrderSubsXML" XMLFile="NW_OrderSubtotals.xml" IdeDisplayStatus="Collapsed" />
    </Join>
    <Join ID="joinInner2" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" />
      <DataLayer Type="XMLFile" ID="dlEmployeesXML" XMLFile="NW_Employees.xml" />
    </Join>
    <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShippedYear" TimePeriod="Year" />
    <SortFilter SortColumn="LastName" DataType="Text" SortSequence="Ascending" />
    <CrosstabFilter CrosstabColumn="tpcShippedYear" CrosstabLabelColumn="EmployeeID" CrosstabValueColumn="Subtotal" CrosstabValueFunction="Sum" ID="CrosstabFilter1" IdeDisplayStatus="Collapsed">
      <ExtraCrosstabLabelColumn CrosstabLabelColumn="LastName" ID="LastName" />
      <ExtraCrosstabLabelColumn CrosstabLabelColumn="FirstName" ID="FirstName" />
      <CrosstabRowSummaryColumn Function="Sum" ID="crsSum" />
      <CrosstabRowSummaryColumn Function="Average" ID="crsAvg" />
      <CrosstabRowSummaryColumn Function="CountOfAllRows" ID="crsCount" />
    </CrosstabFilter>
  </DataLayer>
  <CrosstabTableLabelColumn Header="Employee Name" ID="colEmployeeName" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed">
    <Label Caption="=Trim(&quot;&quot;) + &quot;, &quot; + &quot;&quot;" ID="lblEmployeeName" />
    <DataColumnSort DataColumn="LastName" DataType="Text" />
  </CrosstabTableLabelColumn>
  <CrosstabTableValueColumns Header="" ID="colsData" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="Currency" ID="lblCrosstabValue" Tooltip="Click for details" />
    <DataColumnSummary DataColumn="rdCrosstabColumn" Function="Sum" ID="dcsSumData" />
    <Spaces />
    <CrosstabValueColumnSort FirstSortSequence="Ascending" DataType="Number" />
  </CrosstabTableValueColumns>
  <CrosstabTableLabelColumn Class="ThemeAlignRight" Header="Sum" ID="colSum" IdeDisplayStatus="Collapsed">
    <Label Format="Currency" ID="lblSum" Caption="" />
    <DataColumnSummary DataColumn="crsSum" Function="Sum" ID="dcsSumSums" />
    <LineBreak />
    <DataColumnSort DataColumn="crsSum" DataType="Number" />
  </CrosstabTableLabelColumn>
  <CrosstabTableLabelColumn Class="ThemeAlignRight" ID="colAvg" Header="Average" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="Avg" Format="Currency" />
    <DataColumnSummary DataColumn="crsAvg" ID="dcsAvg" Function="Average" />
    <DataColumnSort DataColumn="crsAvg" DataType="Number" />
  </CrosstabTableLabelColumn>
  <CrosstabTableLabelColumn Header="# Orders" Class="ThemeAlignRight" ID="colCount" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblCount" />
    <DataColumnSummary DataColumn="crsCount" Function="Sum" ID="dcsSumCount" />
    <DataColumnSort DataColumn="crsCount" DataType="Number" />
  </CrosstabTableLabelColumn>
  <SummaryRow Caption="Totals: " ID="summaryRow" Class="ThemeBold" />
</CrosstabTable>
<CrosstabTable ID="XTab1Basic" AjaxPaging="True" DraggableColumns="True" RememberSort="True" Width="800" WidthScale="px" Caption="Basic Crosstab Table" CaptionClass="ThemeTextLarger, ThemeMarginLarge" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" ID="dlOrders1XML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed"> <ConditionFilter Condition="CXMLDate(&quot;&quot;) &lt;&gt; &quot;&quot;" /> <Join ID="joinInner1" JoinType="InnerJoin" IdeDisplayStatus="Collapsed"> <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" /> <DataLayer Type="XMLFile" ID="dlOrderSubsXML" XMLFile="NW_OrderSubtotals.xml" IdeDisplayStatus="Collapsed" /> </Join> <Join ID="joinInner2" JoinType="InnerJoin" IdeDisplayStatus="Collapsed"> <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" /> <DataLayer Type="XMLFile" ID="dlEmployeesXML" XMLFile="NW_Employees.xml" /> </Join> <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShippedYear" TimePeriod="Year" /> <SortFilter SortColumn="LastName" DataType="Text" SortSequence="Ascending" /> <CrosstabFilter CrosstabColumn="tpcShippedYear" CrosstabLabelColumn="EmployeeID" CrosstabValueColumn="Subtotal" CrosstabValueFunction="Sum" ID="CrosstabFilter1" IdeDisplayStatus="Collapsed"> <ExtraCrosstabLabelColumn CrosstabLabelColumn="LastName" ID="LastName" /> <ExtraCrosstabLabelColumn CrosstabLabelColumn="FirstName" ID="FirstName" /> <CrosstabRowSummaryColumn Function="Sum" ID="crsSum" /> <CrosstabRowSummaryColumn Function="Average" ID="crsAvg" /> <CrosstabRowSummaryColumn Function="CountOfAllRows" ID="crsCount" /> </CrosstabFilter> </DataLayer> <CrosstabTableLabelColumn Header="Employee Name" ID="colEmployeeName" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed"> <Label Caption="=Trim(&quot;&quot;) + &quot;, &quot; + &quot;&quot;" ID="lblEmployeeName" /> <DataColumnSort DataColumn="LastName" DataType="Text" /> </CrosstabTableLabelColumn> <CrosstabTableValueColumns Header="" ID="colsData" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed"> <Label Caption="" Format="Currency" ID="lblCrosstabValue" Tooltip="Click for details" /> <DataColumnSummary DataColumn="rdCrosstabColumn" Function="Sum" ID="dcsSumData" /> <Spaces /> <CrosstabValueColumnSort FirstSortSequence="Ascending" DataType="Number" /> </CrosstabTableValueColumns> <CrosstabTableLabelColumn Class="ThemeAlignRight" Header="Sum" ID="colSum" IdeDisplayStatus="Collapsed"> <Label Format="Currency" ID="lblSum" Caption="" /> <DataColumnSummary DataColumn="crsSum" Function="Sum" ID="dcsSumSums" /> <LineBreak /> <DataColumnSort DataColumn="crsSum" DataType="Number" /> </CrosstabTableLabelColumn> <CrosstabTableLabelColumn Class="ThemeAlignRight" ID="colAvg" Header="Average" IdeDisplayStatus="Collapsed"> <Label Caption="" ID="Avg" Format="Currency" /> <DataColumnSummary DataColumn="crsAvg" ID="dcsAvg" Function="Average" /> <DataColumnSort DataColumn="crsAvg" DataType="Number" /> </CrosstabTableLabelColumn> <CrosstabTableLabelColumn Header="# Orders" Class="ThemeAlignRight" ID="colCount" IdeDisplayStatus="Collapsed"> <Label Caption="" ID="lblCount" /> <DataColumnSummary DataColumn="crsCount" Function="Sum" ID="dcsSumCount" /> <DataColumnSort DataColumn="crsCount" DataType="Number" /> </CrosstabTableLabelColumn> <SummaryRow Caption="Totals: " ID="summaryRow" Class="ThemeBold" /> </CrosstabTable>
...with Alternating Row Colors, Drilldown, and Column Differences
Employee Name20112012SumAverageDifference $Difference %
Buchanan, Steven$31,433.19 $19,691.90 $51,125.09
$25,562.55-$11,741.29-37.35%
Callahan, Laura$56,954.04 $47,727.95 $104,681.99
$52,341.00-$9,226.09-16.20%
Davolio, Nancy$95,850.40 $60,565.22 $156,415.62
$78,207.81-$35,285.18-36.81%
Dodsworth, Anne$24,412.89 $42,142.66 $66,555.55
$33,277.78$17,729.7772.62%
Fuller, Andrew$71,168.14 $73,790.18 $144,958.32
$72,479.16$2,622.043.68%
King, Robert$59,827.19 $44,559.89 $104,387.08
$52,193.54-$15,267.30-25.52%
Leverling, Janet$103,719.08 $80,869.80 $184,588.88
$92,294.44-$22,849.28-22.03%
Peacock, Margaret$124,655.57 $51,163.01 $175,818.58
$87,909.29-$73,492.56-58.96%
Suyama, Michael$40,826.37 $17,181.58 $58,007.95
$29,003.98-$23,644.79-57.92%
Totals:$608,846.87$437,692.19$1,046,539.06$58,141.06-$171,154.68-28.11%

  This Crosstab Table element includes:

  • Sum & Average columns
  • Column differences by amount & percent
  • Custom Summary Row calculations
  • Drilldown to detail (click a value)

<CrosstabTable ID="XTab2ColDiffs" AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="...with Alternating Row Colors, Drilldown, and Column Differences" CaptionClass="ThemeTextLarger, ThemeMarginLarge" Width="800" WidthScale="px" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrders2XML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <ConditionFilter Condition="CXMLDate(&quot;&quot;) &lt;&gt; &quot;&quot; And Year(CXMLDate(&quot;&quot;)) &lt;&gt; &quot;2010&quot;" />
    <Join ID="joinInner1" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" />
      <DataLayer Type="XMLFile" ID="dlOrderSubsXML" XMLFile="NW_OrderSubtotals.xml" />
    </Join>
    <Join ID="joinInner2" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" />
      <DataLayer Type="XMLFile" ID="dlEmployeesXML" XMLFile="NW_Employees.xml" />
    </Join>
    <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShippedYear" TimePeriod="Year" />
    <SortFilter SortColumn="LastName" DataType="Text" SortSequence="Ascending" />
    <CrosstabFilter CrosstabColumn="tpcShippedYear" CrosstabLabelColumn="EmployeeID" CrosstabValueColumn="Subtotal" CrosstabValueFunction="Sum" ID="CrosstabFilter2" IdeDisplayStatus="Collapsed">
      <ExtraCrosstabLabelColumn CrosstabLabelColumn="LastName" ID="LastName" />
      <ExtraCrosstabLabelColumn CrosstabLabelColumn="FirstName" ID="FirstName" />
      <CrosstabRowSummaryColumn Function="Sum" ID="crsSum" />
      <CrosstabRowSummaryColumn Function="Average" ID="crsAvg" />
    </CrosstabFilter>
  </DataLayer>
  <CrosstabTableLabelColumn Header="Employee Name" ID="colEmployeeName" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed">
    <Label Caption="=Trim(&quot;&quot;) + &quot;, &quot; + &quot;&quot;" ID="lblEmployeeName" />
    <DataColumnSort DataColumn="LastName" />
  </CrosstabTableLabelColumn>
  <CrosstabTableValueColumns Header="" ID="colsData" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="Currency" ID="lblCrosstabValue" IdeDisplayStatus="Collapsed">
      <Action Type="Report" ID="actDrillReport" IdeDisplayStatus="Collapsed">
        <Target Type="Report" Report="DrillDownTarget" />
        <LinkParams OrderYear="" EmployeeID="" EmployeeName="" />
      </Action>
    </Label>
    <DataColumnSummary DataColumn="rdCrosstabColumn" Function="Sum" ID="dcsSumData2" />
    <Spaces />
    <CrosstabValueColumnSort FirstSortSequence="Ascending" />
  </CrosstabTableValueColumns>
  <CrosstabTableLabelColumn Class="ThemeAlignRight" Header="Sum" ID="colSum" IdeDisplayStatus="Collapsed">
    <Label Format="Currency" ID="lblSum" Caption="" />
    <DataColumnSummary DataColumn="crsSum" Function="Sum" ID="dcsSumSums2" />
    <LineBreak />
    <DataColumnSort DataColumn="crsSum" />
  </CrosstabTableLabelColumn>
  <CrosstabTableLabelColumn Class="ThemeAlignRight" ID="colAvg" Header="Average" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="Avg" Format="Currency" />
    <DataColumnSummary DataColumn="crsAvg" ID="dcsAvg2" Function="Average" />
    <DataColumnSort DataColumn="crsAvg" />
  </CrosstabTableLabelColumn>
  <CrosstabTableLabelColumn Header="Difference $" Class="ThemeAlignRight" ID="colDiffDollar" IdeDisplayStatus="Collapsed">
    <Label Caption="= - &#xD;&#xA;&#xD;&#xA;" ID="lblDiff" Format="$###,###.00" />
  </CrosstabTableLabelColumn>
  <CrosstabTableLabelColumn Header="Difference %" Class="ThemeAlignRight" ID="colDiffPcnt" IdeDisplayStatus="Collapsed">
    <Label Caption="=IIF( -  &lt; 1, ( - )/, (/) - 1 )&#xD;&#xA;&#xD;&#xA;" ID="lblPcntDiff" Format="Percent" />
  </CrosstabTableLabelColumn>
  <Remark>
    <Note Note="Standard automatic summaries" />
  </Remark>
  <Remark>
    <SummaryRow Caption="Totals: " ID="summaryRowAuto" Class="ThemeBold" />
  </Remark>
  <Remark>
    <Note Note="Special custom summaries include calculations to summarize Difference columns" />
  </Remark>
  <SummaryRow Caption="Totals: " ID="summaryRowCustom" Class="Bold" IdeDisplayStatus="Collapsed">
    <Column Class="ThemeAlignLeft" ID="colTotals" IdeDisplayStatus="Collapsed">
      <Label ID="lblSpace" Caption="Totals:" />
    </Column>
    <CrosstabTableSummaryColumn ID="crosstabSumData" Class="ThemeAlignRight, padR6" IdeDisplayStatus="Collapsed">
      <Label ID="lblSumData2" Caption="0" Format="Currency" />
    </CrosstabTableSummaryColumn>
    <Column Class="ThemeAlignRight, padR6" ID="colSum" IdeDisplayStatus="Collapsed">
      <Label ID="lblSumSums2" Caption="1046539.06" Format="Currency" />
    </Column>
    <Column Class="ThemeAlignRight, padR6" ID="colAvg" IdeDisplayStatus="Collapsed">
      <Label ID="lblsumAvg2" Caption="58141.058888888888888888888889" Format="Currency" />
    </Column>
    <Column Class="ThemeAlignRight, padR6" ID="colDiffDollar" IdeDisplayStatus="Collapsed">
      <Remark>
        <Label ID="lblDiff" Caption="= - " Format="$###,###.00" IdeDisplayStatus="Collapsed">
          <Note Note="This label calculates the sum total of the difference between the first and second columns" />
        </Label>
      </Remark>
      <Label ID="lblDiff" Caption="=437692.19 - 608846.87" Format="$###,###.00" IdeDisplayStatus="Collapsed">
        <Note Note="This label calculates the sum total of the difference between the first and second columns" />
      </Label>
    </Column>
    <Column Class="ThemeAlignRight, padR6" ID="colDiffPcnt" IdeDisplayStatus="Collapsed">
      <Label ID="lblDiffPcnt" Caption="=IIF(437692.19 - 608846.87 &lt; 1, (437692.19 - 608846.87)/608846.87, (437692.19/608846.87) - 1 )&#xD;&#xA;&#xD;&#xA;" Format="Percent" IdeDisplayStatus="Collapsed">
        <Note Note="This label calculates the sum total percentage of the difference between the first and second columns" />
      </Label>
    </Column>
  </SummaryRow>
</CrosstabTable>
<CrosstabTable ID="XTab2ColDiffs" AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="...with Alternating Row Colors, Drilldown, and Column Differences" CaptionClass="ThemeTextLarger, ThemeMarginLarge" Width="800" WidthScale="px" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" ID="dlOrders2XML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed"> <ConditionFilter Condition="CXMLDate(&quot;&quot;) &lt;&gt; &quot;&quot; And Year(CXMLDate(&quot;&quot;)) &lt;&gt; &quot;2010&quot;" /> <Join ID="joinInner1" JoinType="InnerJoin" IdeDisplayStatus="Collapsed"> <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" /> <DataLayer Type="XMLFile" ID="dlOrderSubsXML" XMLFile="NW_OrderSubtotals.xml" /> </Join> <Join ID="joinInner2" JoinType="InnerJoin" IdeDisplayStatus="Collapsed"> <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" /> <DataLayer Type="XMLFile" ID="dlEmployeesXML" XMLFile="NW_Employees.xml" /> </Join> <TimePeriodColumn DataColumn="ShippedDate" ID="tpcShippedYear" TimePeriod="Year" /> <SortFilter SortColumn="LastName" DataType="Text" SortSequence="Ascending" /> <CrosstabFilter CrosstabColumn="tpcShippedYear" CrosstabLabelColumn="EmployeeID" CrosstabValueColumn="Subtotal" CrosstabValueFunction="Sum" ID="CrosstabFilter2" IdeDisplayStatus="Collapsed"> <ExtraCrosstabLabelColumn CrosstabLabelColumn="LastName" ID="LastName" /> <ExtraCrosstabLabelColumn CrosstabLabelColumn="FirstName" ID="FirstName" /> <CrosstabRowSummaryColumn Function="Sum" ID="crsSum" /> <CrosstabRowSummaryColumn Function="Average" ID="crsAvg" /> </CrosstabFilter> </DataLayer> <CrosstabTableLabelColumn Header="Employee Name" ID="colEmployeeName" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed"> <Label Caption="=Trim(&quot;&quot;) + &quot;, &quot; + &quot;&quot;" ID="lblEmployeeName" /> <DataColumnSort DataColumn="LastName" /> </CrosstabTableLabelColumn> <CrosstabTableValueColumns Header="" ID="colsData" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed"> <Label Caption="" Format="Currency" ID="lblCrosstabValue" IdeDisplayStatus="Collapsed"> <Action Type="Report" ID="actDrillReport" IdeDisplayStatus="Collapsed"> <Target Type="Report" Report="DrillDownTarget" /> <LinkParams OrderYear="" EmployeeID="" EmployeeName="" /> </Action> </Label> <DataColumnSummary DataColumn="rdCrosstabColumn" Function="Sum" ID="dcsSumData2" /> <Spaces /> <CrosstabValueColumnSort FirstSortSequence="Ascending" /> </CrosstabTableValueColumns> <CrosstabTableLabelColumn Class="ThemeAlignRight" Header="Sum" ID="colSum" IdeDisplayStatus="Collapsed"> <Label Format="Currency" ID="lblSum" Caption="" /> <DataColumnSummary DataColumn="crsSum" Function="Sum" ID="dcsSumSums2" /> <LineBreak /> <DataColumnSort DataColumn="crsSum" /> </CrosstabTableLabelColumn> <CrosstabTableLabelColumn Class="ThemeAlignRight" ID="colAvg" Header="Average" IdeDisplayStatus="Collapsed"> <Label Caption="" ID="Avg" Format="Currency" /> <DataColumnSummary DataColumn="crsAvg" ID="dcsAvg2" Function="Average" /> <DataColumnSort DataColumn="crsAvg" /> </CrosstabTableLabelColumn> <CrosstabTableLabelColumn Header="Difference $" Class="ThemeAlignRight" ID="colDiffDollar" IdeDisplayStatus="Collapsed"> <Label Caption="= - &#xD;&#xA;&#xD;&#xA;" ID="lblDiff" Format="$###,###.00" /> </CrosstabTableLabelColumn> <CrosstabTableLabelColumn Header="Difference %" Class="ThemeAlignRight" ID="colDiffPcnt" IdeDisplayStatus="Collapsed"> <Label Caption="=IIF( - &lt; 1, ( - )/, (/) - 1 )&#xD;&#xA;&#xD;&#xA;" ID="lblPcntDiff" Format="Percent" /> </CrosstabTableLabelColumn> <Remark> <Note Note="Standard automatic summaries" /> </Remark> <Remark> <SummaryRow Caption="Totals: " ID="summaryRowAuto" Class="ThemeBold" /> </Remark> <Remark> <Note Note="Special custom summaries include calculations to summarize Difference columns" /> </Remark> <SummaryRow Caption="Totals: " ID="summaryRowCustom" Class="Bold" IdeDisplayStatus="Collapsed"> <Column Class="ThemeAlignLeft" ID="colTotals" IdeDisplayStatus="Collapsed"> <Label ID="lblSpace" Caption="Totals:" /> </Column> <CrosstabTableSummaryColumn ID="crosstabSumData" Class="ThemeAlignRight, padR6" IdeDisplayStatus="Collapsed"> <Label ID="lblSumData2" Caption="0" Format="Currency" /> </CrosstabTableSummaryColumn> <Column Class="ThemeAlignRight, padR6" ID="colSum" IdeDisplayStatus="Collapsed"> <Label ID="lblSumSums2" Caption="1046539.06" Format="Currency" /> </Column> <Column Class="ThemeAlignRight, padR6" ID="colAvg" IdeDisplayStatus="Collapsed"> <Label ID="lblsumAvg2" Caption="58141.058888888888888888888889" Format="Currency" /> </Column> <Column Class="ThemeAlignRight, padR6" ID="colDiffDollar" IdeDisplayStatus="Collapsed"> <Remark> <Label ID="lblDiff" Caption="= - " Format="$###,###.00" IdeDisplayStatus="Collapsed"> <Note Note="This label calculates the sum total of the difference between the first and second columns" /> </Label> </Remark> <Label ID="lblDiff" Caption="=437692.19 - 608846.87" Format="$###,###.00" IdeDisplayStatus="Collapsed"> <Note Note="This label calculates the sum total of the difference between the first and second columns" /> </Label> </Column> <Column Class="ThemeAlignRight, padR6" ID="colDiffPcnt" IdeDisplayStatus="Collapsed"> <Label ID="lblDiffPcnt" Caption="=IIF(437692.19 - 608846.87 &lt; 1, (437692.19 - 608846.87)/608846.87, (437692.19/608846.87) - 1 )&#xD;&#xA;&#xD;&#xA;" Format="Percent" IdeDisplayStatus="Collapsed"> <Note Note="This label calculates the sum total percentage of the difference between the first and second columns" /> </Label> </Column> </SummaryRow> </CrosstabTable>
...with Column Comparison Indicators and Tooltips
Employee Name201020112012
Buchanan, Steven$17,667.20  $31,433.19 ↑$19,691.90 ↓
Callahan, Laura$19,160.70  $56,954.04 ↑$47,727.95 ↓
Davolio, Nancy$30,861.76  $95,850.40 ↑$60,565.22 ↓
Dodsworth, Anne$9,894.52  $24,412.89 ↑$42,142.66 ↑
Fuller, Andrew$17,811.46  $71,168.14 ↑$73,790.18 ↑
King, Robert$15,232.16  $59,827.19 ↑$44,559.89 ↓
Leverling, Janet$18,223.96  $103,719.08 ↑$80,869.80 ↓
Peacock, Margaret$49,945.12  $124,655.57 ↑$51,163.01 ↓
Suyama, Michael$14,519.69  $40,826.37 ↑$17,181.58 ↓
Totals: $193,316.57$608,846.87$437,692.19

  This Crosstab Table element includes:

  • Column comparison indicators
  • Column comparison tooltips

<CrosstabTable ID="XTab3ColComp" AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="...with Column Comparison Indicators and Tooltips" CaptionClass="ThemeTextLarger, ThemeMarginLarge" Width="800" WidthScale="px" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrders3XML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <ConditionFilter Condition="CXMLDate(&quot;&quot;) &lt;&gt; &quot;&quot;" />
    <Join ID="joinInner1" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" />
      <DataLayer Type="XMLFile" ID="dlOrderSubsXML" XMLFile="NW_OrderSubtotals.xml" />
    </Join>
    <Join ID="joinInner2" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" />
      <DataLayer Type="XMLFile" ID="dlEmployeesXML" XMLFile="NW_Employees.xml" />
    </Join>
    <CalculatedColumn Formula="Year(CXMLDate(&quot;&quot;))" ID="calcShippedYear" />
    <SortFilter SortColumn="LastName" DataType="Text" SortSequence="Ascending" />
    <CrosstabFilter CrosstabColumn="calcShippedYear" CrosstabLabelColumn="EmployeeID" CrosstabValueColumn="Subtotal" CrosstabValueFunction="Sum" ID="CrosstabFilter3" IdeDisplayStatus="Collapsed">
      <ExtraCrosstabLabelColumn CrosstabLabelColumn="LastName" ID="LastName" />
      <ExtraCrosstabLabelColumn CrosstabLabelColumn="FirstName" ID="FirstName" />
    </CrosstabFilter>
  </DataLayer>
  <CrosstabTableLabelColumn Header="Employee Name" ID="colEmployeeName" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed">
    <Label Caption="=Trim(&quot;&quot;) + &quot;, &quot; + &quot;&quot;" ID="lblEmployeeName" />
    <DataColumnSort DataColumn="LastName" />
  </CrosstabTableLabelColumn>
  <CrosstabTableValueColumns Header="" ID="colsData" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="Currency" ID="lblCrosstabValue" />
    <DataColumnSummary DataColumn="rdCrosstabColumn" Function="Sum" ID="dcsSumData3" />
    <Spaces />
    <CrosstabValueColumnSort FirstSortSequence="Ascending" />
  </CrosstabTableValueColumns>
  <CrosstabComparison ID="xtabComparison" ComparisonShowTooltips="All" ComparisonStyle="Arrows" />
  <SummaryRow Caption="Totals: " ID="summaryRow" Class="ThemeBold" />
</CrosstabTable>
<CrosstabTable ID="XTab3ColComp" AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="...with Column Comparison Indicators and Tooltips" CaptionClass="ThemeTextLarger, ThemeMarginLarge" Width="800" WidthScale="px" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" ID="dlOrders3XML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed"> <ConditionFilter Condition="CXMLDate(&quot;&quot;) &lt;&gt; &quot;&quot;" /> <Join ID="joinInner1" JoinType="InnerJoin" IdeDisplayStatus="Collapsed"> <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" /> <DataLayer Type="XMLFile" ID="dlOrderSubsXML" XMLFile="NW_OrderSubtotals.xml" /> </Join> <Join ID="joinInner2" JoinType="InnerJoin" IdeDisplayStatus="Collapsed"> <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" /> <DataLayer Type="XMLFile" ID="dlEmployeesXML" XMLFile="NW_Employees.xml" /> </Join> <CalculatedColumn Formula="Year(CXMLDate(&quot;&quot;))" ID="calcShippedYear" /> <SortFilter SortColumn="LastName" DataType="Text" SortSequence="Ascending" /> <CrosstabFilter CrosstabColumn="calcShippedYear" CrosstabLabelColumn="EmployeeID" CrosstabValueColumn="Subtotal" CrosstabValueFunction="Sum" ID="CrosstabFilter3" IdeDisplayStatus="Collapsed"> <ExtraCrosstabLabelColumn CrosstabLabelColumn="LastName" ID="LastName" /> <ExtraCrosstabLabelColumn CrosstabLabelColumn="FirstName" ID="FirstName" /> </CrosstabFilter> </DataLayer> <CrosstabTableLabelColumn Header="Employee Name" ID="colEmployeeName" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed"> <Label Caption="=Trim(&quot;&quot;) + &quot;, &quot; + &quot;&quot;" ID="lblEmployeeName" /> <DataColumnSort DataColumn="LastName" /> </CrosstabTableLabelColumn> <CrosstabTableValueColumns Header="" ID="colsData" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed"> <Label Caption="" Format="Currency" ID="lblCrosstabValue" /> <DataColumnSummary DataColumn="rdCrosstabColumn" Function="Sum" ID="dcsSumData3" /> <Spaces /> <CrosstabValueColumnSort FirstSortSequence="Ascending" /> </CrosstabTableValueColumns> <CrosstabComparison ID="xtabComparison" ComparisonShowTooltips="All" ComparisonStyle="Arrows" /> <SummaryRow Caption="Totals: " ID="summaryRow" Class="ThemeBold" /> </CrosstabTable>
...with Multi-Column Header Row and Column Comparisons
 201420152016Total
SupplierProduct NameTotal SalesUnits SoldAvg PriceTotal SalesUnits SoldAvg PriceTotal SalesUnits SoldAvg PriceTotal SalesUnits SoldAvg Price
Exotic LiquidsAniseed Syrup$240.0030$8.00$1,724.00190$9.07$1,080.00108$10.00$3,044.00328$9.28
Forets d'erablesSirop d'erable$1,113.0042$26.50$9,091.50396$22.96$5,261.10207$25.42$15,465.60645$23.98
Grandma Kelly's HomesteadGrandma's Boysenberry Spread$720.0036$20.00$2,500.00100$25.00$3,917.00165$23.74$7,137.00301$23.71
Grandma Kelly's Homestead
Northwoods Cranberry Sauce$3,920.00140$28.00$4,260.00114$37.37$4,592.00118$38.92$12,772.00372$34.33
Leka TradingGula Malacca$2,042.13138$14.80$6,737.94396$17.02$1,135.8867$16.95$9,915.95601$16.50
Mayumi'sGenen Shouyu$310.0025$12.40$1,474.8397$15.20$363.0022$16.50$2,147.83144$14.92
New Orleans Cajun DelightsChef Anton's Cajun Seasoning$1,851.52107$17.30$5,214.88264$19.75$1,501.5082$18.31$8,567.90453$18.91
New Orleans Cajun Delights
Chef Anton's Gumbo Mix$1,931.20129$14.97$373.6319$19.66$3,042.38150$20.28$5,347.20298$17.94
New Orleans Cajun Delights
Louisiana Fiery Hot Pepper Sauce$2,473.80155$15.96$9,373.19490$19.13$2,022.91100$20.23$13,869.89745$18.62
New Orleans Cajun Delights
Louisiana Hot Spiced Okra$408.0030$13.60$2,958.00208$14.22$831.3648$17.32$4,197.36286$14.68
Pavlova, Ltd.Vegie-spread$3,348.54109$30.72$6,899.26189$36.50$6,453.30147$43.90$16,701.10445$37.53
Plutzer LebensgrossmarkteOriginal Frankfurter grune Sosse$655.2063$10.40$4,761.38432$11.02$3,755.05296$12.69$9,171.63791$11.59

Totals:
$19,013.39
1,004
$18.94
$55,368.59
2,895
$19.13
$33,955.47
1,510
$22.49
$108,337.45
5,409
$20.03

  This Crosstab Table element includes:

  • Header Row for multi-column header
  • Multiple value columns
  • Row and column summaries

<CrosstabTable ID="XTab4Multi" AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="...with Multi-Column Header Row and Column Comparisons" CaptionClass="ThemeTextLarger, ThemeMarginLarge" Width="1000" WidthScale="px" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" XMLFile="NW_SalesByProduct.xml" ID="dlSalesByProductXML" IdeDisplayStatus="Collapsed">
    <CompareFilter DataColumn="CategoryName" CompareType="=" CompareValue="Condiments" DataType="Text" />
    <CalculatedColumn ID="ODTotal" Formula="**(1-)" />
    <CrosstabFilter CrosstabColumn="OrderYear" CrosstabLabelColumn="ProductName" CrosstabValueColumn="Quantity" CrosstabValueFunction="Sum" ID="CrosstabFilter4" IdeDisplayStatus="Collapsed">
      <ExtraCrosstabLabelColumn CrosstabLabelColumn="CompanyName" ID="CompanyName" />
      <ExtraCrosstabValueColumn ID="ODTotal" CrosstabValueColumn="OrderTotals" CrosstabValueFunction="Sum" />
      <ExtraCrosstabCalculatedColumn ID="UnitPrice" Formula="/" ErrorResult="0" />
      <CrosstabRowSummaryColumn Function="Sum" ID="crsSumQuantity" />
      <CrosstabRowSummaryColumn ID="crsSumODTotal" Function="Sum" ExtraCrosstabValueColumnID="ODTotal" />
    </CrosstabFilter>
    <SortFilter SortColumn="CompanyName" DataType="Text" />
  </DataLayer>
  <HeaderRow ID="HeaderRow" HeaderPosition="Top" IdeDisplayStatus="Collapsed">
    <Column ID="colSpacer" RowSpan="" ColSpan="2" IdeDisplayStatus="Collapsed">
      <Spaces />
    </Column>
    <CrosstabTableHeaderColumn ID="colCrossTabHeader" Class="fontHeaderRow" ColSpan="3" IdeDisplayStatus="Collapsed">
      <Label ID="lblRdCrosstabColumn" Caption="" />
    </CrosstabTableHeaderColumn>
    <Column ID="colTotal" ColSpan="3" Class="fontHeaderRow" IdeDisplayStatus="Collapsed">
      <Label ID="lblTotal" Caption="Total" />
    </Column>
  </HeaderRow>
  <CrosstabTableLabelColumn ID="colCompanyName" Header="Supplier" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed">
    <Label ID="lblCompanyName" Caption="" />
    <HideDuplicates DataColumn="CompanyName" />
  </CrosstabTableLabelColumn>
  <CrosstabTableLabelColumn ID="colProductName" Header="Product Name" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed">
    <Label ID="lblProductName" Caption="" />
  </CrosstabTableLabelColumn>
  <CrosstabTableValueColumns ID="colODTotal" Header="Total Sales" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblODTotal" Caption="" Format="Currency" />
    <DataColumnSummary DataColumn="rdCrosstabValue-ODTotal" Function="Sum" ID="dcsSumODTotal" />
  </CrosstabTableValueColumns>
  <CrosstabTableValueColumns ID="colQuantity" Header="Units Sold" Class="ThemeAlignRight" Width="50" WidthScale="px" IdeDisplayStatus="Collapsed">
    <Label ID="lblQuantity" Caption="" Format="###,###,##0" />
    <DataColumnSummary DataColumn="rdCrosstabValue" Function="Sum" ID="dcsSumQuantity" />
  </CrosstabTableValueColumns>
  <CrosstabTableValueColumns ID="colAvgUnitPrice" Header="Avg Price" Class="ThemeAlignRight" Width="50" WidthScale="px" IdeDisplayStatus="Collapsed">
    <Label ID="lblUnitPrice" Caption="" Format="Currency" />
  </CrosstabTableValueColumns>
  <CrosstabTableLabelColumn ID="RowTotal" Header="Total Sales" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblcrsSumODTotal" Format="Currency" />
    <DataColumnSummary Function="Sum" ID="dcsSumRowODTotal" DataColumn="crsSumODTotal" />
  </CrosstabTableLabelColumn>
  <CrosstabTableLabelColumn ID="RowTotalQuantity" Header="Units Sold" Class="ThemeAlignRight" Width="50" WidthScale="px" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblcrsSumQuantity" Format="###,###,##0" />
    <DataColumnSummary Function="Sum" ID="dcsSumRowSums" DataColumn="crsSumQuantity" />
  </CrosstabTableLabelColumn>
  <CrosstabTableLabelColumn ID="RowTotalUnitPrice" Header="Avg Price" Class="ThemeAlignRight" WidthScale="px" Width="50" IdeDisplayStatus="Collapsed">
    <Label Caption="=/" ID="lblAvgUnitPrice" Format="Currency" ErrorResult="0" />
  </CrosstabTableLabelColumn>
  <SummaryRow ID="SummaryRow" Caption="Totals: " Class="ThemeBold" IdeDisplayStatus="Collapsed">
    <Column ColSpan="2" ID="cellTotal" IdeDisplayStatus="Collapsed">
      <LineBreak />
      <Label Caption="Totals: " ID="lblTotals" />
    </Column>
    <CrosstabTableSummaryColumn Class="ThemeAlignRight" ID="cellsumODTotal" ColSpan="1" IdeDisplayStatus="Collapsed">
      <LineBreak />
      <Label Caption="0" ID="lblsumODTotal" Format="Currency" />
    </CrosstabTableSummaryColumn>
    <CrosstabTableSummaryColumn Class="ThemeAlignRight" ID="cellsumQuantity" ColSpan="1" IdeDisplayStatus="Collapsed">
      <LineBreak />
      <Label Caption="0" ID="lblsumQuantity" Format="###,###,##0" />
    </CrosstabTableSummaryColumn>
    <CrosstabTableSummaryColumn Class="ThemeAlignRight" ID="cellsumUnitPrice" ColSpan="1" IdeDisplayStatus="Collapsed">
      <LineBreak />
      <Label Caption="=0/0" ID="lblsumUnitPrice" ErrorResult="0" Format="Currency" />
    </CrosstabTableSummaryColumn>
    <Column ID="cellsumRowSumODTotal" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
      <LineBreak />
      <Label ID="lblsumRowSumODTotal" Caption="108337.44551" Format="Currency" />
    </Column>
    <Column ID="cellsumRowSum" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
      <LineBreak />
      <Label ID="lblsumRowSum" Caption="5409" Format="###,###,##0" />
    </Column>
    <Column ID="cellsumRowSumUnitPrice" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
      <LineBreak />
      <Label ID="lblSumRowSumUnitPrice" Caption="=108337.44551/5409" Format="Currency" ErrorResult="0" />
    </Column>
  </SummaryRow>
</CrosstabTable>
<CrosstabTable ID="XTab4Multi" AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="...with Multi-Column Header Row and Column Comparisons" CaptionClass="ThemeTextLarger, ThemeMarginLarge" Width="1000" WidthScale="px" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" XMLFile="NW_SalesByProduct.xml" ID="dlSalesByProductXML" IdeDisplayStatus="Collapsed"> <CompareFilter DataColumn="CategoryName" CompareType="=" CompareValue="Condiments" DataType="Text" /> <CalculatedColumn ID="ODTotal" Formula="**(1-)" /> <CrosstabFilter CrosstabColumn="OrderYear" CrosstabLabelColumn="ProductName" CrosstabValueColumn="Quantity" CrosstabValueFunction="Sum" ID="CrosstabFilter4" IdeDisplayStatus="Collapsed"> <ExtraCrosstabLabelColumn CrosstabLabelColumn="CompanyName" ID="CompanyName" /> <ExtraCrosstabValueColumn ID="ODTotal" CrosstabValueColumn="OrderTotals" CrosstabValueFunction="Sum" /> <ExtraCrosstabCalculatedColumn ID="UnitPrice" Formula="/" ErrorResult="0" /> <CrosstabRowSummaryColumn Function="Sum" ID="crsSumQuantity" /> <CrosstabRowSummaryColumn ID="crsSumODTotal" Function="Sum" ExtraCrosstabValueColumnID="ODTotal" /> </CrosstabFilter> <SortFilter SortColumn="CompanyName" DataType="Text" /> </DataLayer> <HeaderRow ID="HeaderRow" HeaderPosition="Top" IdeDisplayStatus="Collapsed"> <Column ID="colSpacer" RowSpan="" ColSpan="2" IdeDisplayStatus="Collapsed"> <Spaces /> </Column> <CrosstabTableHeaderColumn ID="colCrossTabHeader" Class="fontHeaderRow" ColSpan="3" IdeDisplayStatus="Collapsed"> <Label ID="lblRdCrosstabColumn" Caption="" /> </CrosstabTableHeaderColumn> <Column ID="colTotal" ColSpan="3" Class="fontHeaderRow" IdeDisplayStatus="Collapsed"> <Label ID="lblTotal" Caption="Total" /> </Column> </HeaderRow> <CrosstabTableLabelColumn ID="colCompanyName" Header="Supplier" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed"> <Label ID="lblCompanyName" Caption="" /> <HideDuplicates DataColumn="CompanyName" /> </CrosstabTableLabelColumn> <CrosstabTableLabelColumn ID="colProductName" Header="Product Name" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed"> <Label ID="lblProductName" Caption="" /> </CrosstabTableLabelColumn> <CrosstabTableValueColumns ID="colODTotal" Header="Total Sales" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed"> <Label ID="lblODTotal" Caption="" Format="Currency" /> <DataColumnSummary DataColumn="rdCrosstabValue-ODTotal" Function="Sum" ID="dcsSumODTotal" /> </CrosstabTableValueColumns> <CrosstabTableValueColumns ID="colQuantity" Header="Units Sold" Class="ThemeAlignRight" Width="50" WidthScale="px" IdeDisplayStatus="Collapsed"> <Label ID="lblQuantity" Caption="" Format="###,###,##0" /> <DataColumnSummary DataColumn="rdCrosstabValue" Function="Sum" ID="dcsSumQuantity" /> </CrosstabTableValueColumns> <CrosstabTableValueColumns ID="colAvgUnitPrice" Header="Avg Price" Class="ThemeAlignRight" Width="50" WidthScale="px" IdeDisplayStatus="Collapsed"> <Label ID="lblUnitPrice" Caption="" Format="Currency" /> </CrosstabTableValueColumns> <CrosstabTableLabelColumn ID="RowTotal" Header="Total Sales" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed"> <Label Caption="" ID="lblcrsSumODTotal" Format="Currency" /> <DataColumnSummary Function="Sum" ID="dcsSumRowODTotal" DataColumn="crsSumODTotal" /> </CrosstabTableLabelColumn> <CrosstabTableLabelColumn ID="RowTotalQuantity" Header="Units Sold" Class="ThemeAlignRight" Width="50" WidthScale="px" IdeDisplayStatus="Collapsed"> <Label Caption="" ID="lblcrsSumQuantity" Format="###,###,##0" /> <DataColumnSummary Function="Sum" ID="dcsSumRowSums" DataColumn="crsSumQuantity" /> </CrosstabTableLabelColumn> <CrosstabTableLabelColumn ID="RowTotalUnitPrice" Header="Avg Price" Class="ThemeAlignRight" WidthScale="px" Width="50" IdeDisplayStatus="Collapsed"> <Label Caption="=/" ID="lblAvgUnitPrice" Format="Currency" ErrorResult="0" /> </CrosstabTableLabelColumn> <SummaryRow ID="SummaryRow" Caption="Totals: " Class="ThemeBold" IdeDisplayStatus="Collapsed"> <Column ColSpan="2" ID="cellTotal" IdeDisplayStatus="Collapsed"> <LineBreak /> <Label Caption="Totals: " ID="lblTotals" /> </Column> <CrosstabTableSummaryColumn Class="ThemeAlignRight" ID="cellsumODTotal" ColSpan="1" IdeDisplayStatus="Collapsed"> <LineBreak /> <Label Caption="0" ID="lblsumODTotal" Format="Currency" /> </CrosstabTableSummaryColumn> <CrosstabTableSummaryColumn Class="ThemeAlignRight" ID="cellsumQuantity" ColSpan="1" IdeDisplayStatus="Collapsed"> <LineBreak /> <Label Caption="0" ID="lblsumQuantity" Format="###,###,##0" /> </CrosstabTableSummaryColumn> <CrosstabTableSummaryColumn Class="ThemeAlignRight" ID="cellsumUnitPrice" ColSpan="1" IdeDisplayStatus="Collapsed"> <LineBreak /> <Label Caption="=0/0" ID="lblsumUnitPrice" ErrorResult="0" Format="Currency" /> </CrosstabTableSummaryColumn> <Column ID="cellsumRowSumODTotal" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed"> <LineBreak /> <Label ID="lblsumRowSumODTotal" Caption="108337.44551" Format="Currency" /> </Column> <Column ID="cellsumRowSum" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed"> <LineBreak /> <Label ID="lblsumRowSum" Caption="5409" Format="###,###,##0" /> </Column> <Column ID="cellsumRowSumUnitPrice" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed"> <LineBreak /> <Label ID="lblSumRowSumUnitPrice" Caption="=108337.44551/5409" Format="Currency" ErrorResult="0" /> </Column> </SummaryRow> </CrosstabTable>
...with Group Drillthrough
Employee Name201020112012
Buchanan, Steven$17,667.20  Drillthrough$31,433.19  Drillthrough$19,691.90  Drillthrough
Callahan, Laura$19,160.70  Drillthrough$56,954.04  Drillthrough$47,727.95  Drillthrough
Davolio, Nancy$30,861.76  Drillthrough$95,850.40  Drillthrough$60,565.22  Drillthrough
Dodsworth, Anne$9,894.52  Drillthrough$24,412.89  Drillthrough$42,142.66  Drillthrough
Fuller, Andrew$17,811.46  Drillthrough$71,168.14  Drillthrough$73,790.18  Drillthrough
King, Robert$15,232.16  Drillthrough$59,827.19  Drillthrough$44,559.89  Drillthrough
Leverling, Janet$18,223.96  Drillthrough$103,719.08  Drillthrough$80,869.80  Drillthrough
Peacock, Margaret$49,945.12  Drillthrough$124,655.57  Drillthrough$51,163.01  Drillthrough
Suyama, Michael$14,519.69  Drillthrough$40,826.37  Drillthrough$17,181.58  Drillthrough
Totals: $193,316.57$608,846.87$437,692.19

  This Crosstab Table element includes:

  • Group Drillthrough (hover over value, click icon)

<CrosstabTable ID="XTab5Drill" AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Width="800" WidthScale="px" Caption="...with Group Drillthrough" CaptionClass="ThemeTextLarger, ThemeMarginLarge" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrders5XML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <ConditionFilter Condition="CXMLDate(&quot;&quot;) &lt;&gt; &quot;&quot;" />
    <Join ID="joinInner1" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" />
      <DataLayer Type="XMLFile" ID="dlOrderSubsXML" XMLFile="NW_OrderSubtotals.xml" />
    </Join>
    <Join ID="joinInner2" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" />
      <DataLayer Type="XMLFile" ID="dlEmployeesXML" XMLFile="NW_Employees.xml" />
    </Join>
    <CalculatedColumn Formula="Year(CXMLDate(&quot;&quot;))" ID="calcShippedYear" />
    <SortFilter SortColumn="LastName" DataType="Text" SortSequence="Ascending" />
    <CrosstabFilter CrosstabColumn="calcShippedYear" CrosstabLabelColumn="EmployeeID" CrosstabValueColumn="Subtotal" CrosstabValueFunction="Sum" ID="CrosstabFilter5" IdeDisplayStatus="Collapsed">
      <ExtraCrosstabLabelColumn CrosstabLabelColumn="LastName" ID="LastName" />
      <ExtraCrosstabLabelColumn CrosstabLabelColumn="FirstName" ID="FirstName" />
    </CrosstabFilter>
  </DataLayer>
  <CrosstabTableLabelColumn Header="Employee Name" ID="colEmployeeName" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed">
    <Label Caption="=Trim(&quot;&quot;) + &quot;, &quot; + &quot;&quot;" ID="lblEmployeeName" />
    <DataColumnSort DataColumn="LastName" />
  </CrosstabTableLabelColumn>
  <CrosstabTableValueColumns Header="" ID="colsData2" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="Currency" ID="lblCrosstabValue" />
    <DataColumnSummary DataColumn="rdCrosstabColumn" Function="Sum" ID="dcsSumData5" />
    <Spaces />
    <CrosstabValueColumnSort FirstSortSequence="Ascending" />
    <GroupDrillthrough ID="GroupDrill" FrameID="Self" Export="PDF" Caption="Group Drillthrough Report" GroupFilterID="CrosstabFilter5" IdeDisplayStatus="Collapsed">
      <DrillthroughColumn ID="colEmployeeID" Header="EmployeeID" DataColumn="EmployeeID" Caption="ID #" DataType="Number" />
      <DrillthroughColumn ID="colLastName" Header="LastName" DataColumn="LastName" Caption="LastName" DataType="Text" />
      <DrillthroughColumn ID="colFirstName" Header="FirstName" DataColumn="FirstName" Caption="FirstName" DataType="Text" />
      <DrillthroughColumn DataColumn="OrderID" ID="colOrderID" Caption="Order #" DataType="Number" />
      <DrillthroughColumn DataColumn="CustomerID" ID="colCustID" Caption="Cust ID" DataType="Text" />
      <DrillthroughColumn DataColumn="ShippedDate" ID="colShipDate" Caption="Shipped" DataType="Date" Format="Short Date" />
      <DrillthroughColumn DataColumn="Freight" ID="colFreight" Caption="Freight" DataType="Number" Format="Currency" />
      <DrillthroughColumn DataColumn="ShipCountry" ID="colShipCountry" Caption="Country" DataType="Text" />
    </GroupDrillthrough>
  </CrosstabTableValueColumns>
  <SummaryRow Caption="Totals: " ID="summaryRow" Class="ThemeBold" />
</CrosstabTable>
<CrosstabTable ID="XTab5Drill" AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Width="800" WidthScale="px" Caption="...with Group Drillthrough" CaptionClass="ThemeTextLarger, ThemeMarginLarge" IdeDisplayStatus="Collapsed"> <DataLayer Type="XMLFile" ID="dlOrders5XML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed"> <ConditionFilter Condition="CXMLDate(&quot;&quot;) &lt;&gt; &quot;&quot;" /> <Join ID="joinInner1" JoinType="InnerJoin" IdeDisplayStatus="Collapsed"> <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" /> <DataLayer Type="XMLFile" ID="dlOrderSubsXML" XMLFile="NW_OrderSubtotals.xml" /> </Join> <Join ID="joinInner2" JoinType="InnerJoin" IdeDisplayStatus="Collapsed"> <MatchCondition LeftDataColumn="EmployeeID" RightDataColumn="EmployeeID" /> <DataLayer Type="XMLFile" ID="dlEmployeesXML" XMLFile="NW_Employees.xml" /> </Join> <CalculatedColumn Formula="Year(CXMLDate(&quot;&quot;))" ID="calcShippedYear" /> <SortFilter SortColumn="LastName" DataType="Text" SortSequence="Ascending" /> <CrosstabFilter CrosstabColumn="calcShippedYear" CrosstabLabelColumn="EmployeeID" CrosstabValueColumn="Subtotal" CrosstabValueFunction="Sum" ID="CrosstabFilter5" IdeDisplayStatus="Collapsed"> <ExtraCrosstabLabelColumn CrosstabLabelColumn="LastName" ID="LastName" /> <ExtraCrosstabLabelColumn CrosstabLabelColumn="FirstName" ID="FirstName" /> </CrosstabFilter> </DataLayer> <CrosstabTableLabelColumn Header="Employee Name" ID="colEmployeeName" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed"> <Label Caption="=Trim(&quot;&quot;) + &quot;, &quot; + &quot;&quot;" ID="lblEmployeeName" /> <DataColumnSort DataColumn="LastName" /> </CrosstabTableLabelColumn> <CrosstabTableValueColumns Header="" ID="colsData2" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed"> <Label Caption="" Format="Currency" ID="lblCrosstabValue" /> <DataColumnSummary DataColumn="rdCrosstabColumn" Function="Sum" ID="dcsSumData5" /> <Spaces /> <CrosstabValueColumnSort FirstSortSequence="Ascending" /> <GroupDrillthrough ID="GroupDrill" FrameID="Self" Export="PDF" Caption="Group Drillthrough Report" GroupFilterID="CrosstabFilter5" IdeDisplayStatus="Collapsed"> <DrillthroughColumn ID="colEmployeeID" Header="EmployeeID" DataColumn="EmployeeID" Caption="ID #" DataType="Number" /> <DrillthroughColumn ID="colLastName" Header="LastName" DataColumn="LastName" Caption="LastName" DataType="Text" /> <DrillthroughColumn ID="colFirstName" Header="FirstName" DataColumn="FirstName" Caption="FirstName" DataType="Text" /> <DrillthroughColumn DataColumn="OrderID" ID="colOrderID" Caption="Order #" DataType="Number" /> <DrillthroughColumn DataColumn="CustomerID" ID="colCustID" Caption="Cust ID" DataType="Text" /> <DrillthroughColumn DataColumn="ShippedDate" ID="colShipDate" Caption="Shipped" DataType="Date" Format="Short Date" /> <DrillthroughColumn DataColumn="Freight" ID="colFreight" Caption="Freight" DataType="Number" Format="Currency" /> <DrillthroughColumn DataColumn="ShipCountry" ID="colShipCountry" Caption="Country" DataType="Text" /> </GroupDrillthrough> </CrosstabTableValueColumns> <SummaryRow Caption="Totals: " ID="summaryRow" Class="ThemeBold" /> </CrosstabTable>