Logi Crosstab

Sample Crosstab Table

Basic Crosstab Table

Employee Name

Buchanan, Steven

$17,667.20

$31,433.19

$19,691.90

$68,792.29

$22,930.76

Callahan, Laura

$19,160.70

$56,954.04

$47,727.95

$123,842.69

$41,280.90

100

Davolio, Nancy

$30,861.76

$95,850.40

$60,565.22

$187,277.38

$62,425.79

120

Dodsworth, Anne

$9,894.52

$24,412.89

$42,142.66

$76,450.07

$25,483.36

Fuller, Andrew

$17,811.46

$71,168.14

$73,790.18

$162,769.78

$54,256.59

King, Robert

$15,232.16

$59,827.19

$44,559.89

$119,619.24

$39,873.08

Leverling, Janet

$18,223.96

$103,719.08

$80,869.80

$202,812.84

$67,604.28

127

Peacock, Margaret

$49,945.12

$124,655.57

$51,163.01

$225,763.70

$75,254.57

151

Suyama, Michael

$14,519.69

$40,826.37

$17,181.58

$72,527.64

$24,175.88

Totals:

$193,316.57

$608,846.87

$437,692.19

$1,239,855.63

45.9k

809

<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 Name	2016	2017	2018	Sum	Average	Difference $	Difference %
Buchanan, Steven	$17,667.20	$31,433.19	$19,691.90	$68,792.29	$22,930.76	$13,765.99	77.92%
Callahan, Laura	$19,160.70	$56,954.04	$47,727.95	$123,842.69	$41,280.90	$37,793.34	197.24%
Davolio, Nancy	$30,861.76	$95,850.40	$60,565.22	$187,277.38	$62,425.79	$64,988.64	210.58%
Dodsworth, Anne	$9,894.52	$24,412.89	$42,142.66	$76,450.07	$25,483.36	$14,518.37	146.73%
Fuller, Andrew	$17,811.46	$71,168.14	$73,790.18	$162,769.78	$54,256.59	$53,356.68	299.56%
King, Robert	$15,232.16	$59,827.19	$44,559.89	$119,619.24	$39,873.08	$44,595.03	292.77%
Leverling, Janet	$18,223.96	$103,719.08	$80,869.80	$202,812.84	$67,604.28	$85,495.12	469.14%
Peacock, Margaret	$49,945.12	$124,655.57	$51,163.01	$225,763.70	$75,254.57	$74,710.45	149.59%
Suyama, Michael	$14,519.69	$40,826.37	$17,181.58	$72,527.64	$24,175.88	$26,306.68	181.18%
Totals:	$193,316.57	$608,846.87	$437,692.19	$1,239,855.63	$45,920.58	$415,530.30	214.95%

<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="1239855.63" Format="Currency" />
    </Column>
    <Column Class="ThemeAlignRight, padR6" ID="colAvg" IdeDisplayStatus="Collapsed">
      <Label ID="lblsumAvg2" Caption="45920.578888888888888888888889" 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="=608846.87 - 193316.57" 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(608846.87 - 193316.57 &lt; 1, (608846.87 - 193316.57)/193316.57, (608846.87/193316.57) - 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

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

<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
		2014			2015			2016			Total
Supplier	Product Name	Total Sales	Units Sold	Avg Price	Total Sales	Units Sold	Avg Price	Total Sales	Units Sold	Avg Price	Total Sales	Units Sold	Avg Price
Exotic Liquids	Aniseed Syrup	$240.00	30	$8.00	$1,724.00	190	$9.07	$1,080.00	108	$10.00	$3,044.00	328	$9.28
Forets d'erables	Sirop d'erable	$1,113.00	42	$26.50	$9,091.50	396	$22.96	$5,261.10	207	$25.42	$15,465.60	645	$23.98
Grandma Kelly's Homestead	Grandma's Boysenberry Spread	$720.00	36	$20.00	$2,500.00	100	$25.00	$3,917.00	165	$23.74	$7,137.00	301	$23.71
	Northwoods Cranberry Sauce	$3,920.00	140	$28.00	$4,260.00	114	$37.37	$4,592.00	118	$38.92	$12,772.00	372	$34.33
Leka Trading	Gula Malacca	$2,042.13	138	$14.80	$6,737.94	396	$17.02	$1,135.88	67	$16.95	$9,915.95	601	$16.50
Mayumi's	Genen Shouyu	$310.00	25	$12.40	$1,474.83	97	$15.20	$363.00	22	$16.50	$2,147.83	144	$14.92
New Orleans Cajun Delights	Chef Anton's Cajun Seasoning	$1,851.52	107	$17.30	$5,214.88	264	$19.75	$1,501.50	82	$18.31	$8,567.90	453	$18.91
	Chef Anton's Gumbo Mix	$1,931.20	129	$14.97	$373.63	19	$19.66	$3,042.38	150	$20.28	$5,347.20	298	$17.94
	Louisiana Fiery Hot Pepper Sauce	$2,473.80	155	$15.96	$9,373.19	490	$19.13	$2,022.91	100	$20.23	$13,869.89	745	$18.62
	Louisiana Hot Spiced Okra	$408.00	30	$13.60	$2,958.00	208	$14.22	$831.36	48	$17.32	$4,197.36	286	$14.68
Pavlova, Ltd.	Vegie-spread	$3,348.54	109	$30.72	$6,899.26	189	$36.50	$6,453.30	147	$43.90	$16,701.10	445	$37.53
Plutzer Lebensgrossmarkte	Original Frankfurter grune Sosse	$655.20	63	$10.40	$4,761.38	432	$11.02	$3,755.05	296	$12.69	$9,171.63	791	$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

<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 Name	2016	2017	2018
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

<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>

Logi Analytics, Inc. 7900 Westpark Drive, Suite A-200, McLean, Virginia 22102 U.S.A.