﻿<?xml version="1.0" encoding="utf-8"?>
<CrossTab xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" AppVersion="3.1.1.28110" xmlns="http://www.ajbsystems.net">
  <UserIDLastEdited>AJBSystems</UserIDLastEdited>Requires files in time order e.g file 1 = PY, file 2 = CY, file 3 = CY+1.
Does not use any classification variables, so is applicable to all sales databases. 
Selected period must be January to December.
Variance option must be Period Totals only.  <ClassificationVariables /><Columns><CrossTabColumn><OutputColIndex>1</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>010401</ColumnCode><ColumnHeaders>Jan-Apr|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>2</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>010402</ColumnCode><ColumnHeaders>Jan-Apr|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>3</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0201</ColumnCode><ColumnHeaders>Jan-Apr|Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>4</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>0201#0.0</ColumnCode><ColumnHeaders>Jan-Apr|%Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>5</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>010403</ColumnCode><ColumnHeaders>Jan-Apr|F3~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>6</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0502</ColumnCode><ColumnHeaders>Jan-Apr|Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>7</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>0502#0.0</ColumnCode><ColumnHeaders>Jan-Apr|%Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>8</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>050801</ColumnCode><ColumnHeaders>May-Aug|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>9</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>050802</ColumnCode><ColumnHeaders>May-Aug|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>10</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0908</ColumnCode><ColumnHeaders>May-Aug|Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>11</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>0908#0.0</ColumnCode><ColumnHeaders>May-Aug|%Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>12</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>050803</ColumnCode><ColumnHeaders>May-Aug|F3~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>13</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1209</ColumnCode><ColumnHeaders>May-Aug|Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>14</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>1209#0.0</ColumnCode><ColumnHeaders>May-Aug|%Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>15</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>091201</ColumnCode><ColumnHeaders>Sep-Dec|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>16</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>091202</ColumnCode><ColumnHeaders>Sep-Dec|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>17</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1615</ColumnCode><ColumnHeaders>Sep-Dec|Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>18</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>1615#0.0</ColumnCode><ColumnHeaders>Sep-Dec|%Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>19</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>091203</ColumnCode><ColumnHeaders>Sep-Dec|F3~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>20</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1916</ColumnCode><ColumnHeaders>Sep-Dec|Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>21</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>1916#0.0</ColumnCode><ColumnHeaders>Sep-Dec|%Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>22</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011201</ColumnCode><ColumnHeaders>Annual|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>23</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011202</ColumnCode><ColumnHeaders>Annual|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>24</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>2322</ColumnCode><ColumnHeaders>Annual|Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>25</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>2322#0.0</ColumnCode><ColumnHeaders>Annual|%Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>26</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011203</ColumnCode><ColumnHeaders>Annual|F3~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>27</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>2623</ColumnCode><ColumnHeaders>Annual|Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>28</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>2623#0.0</ColumnCode><ColumnHeaders>Annual|%Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn></Columns><OutputPercentTotalColumns>false</OutputPercentTotalColumns><OutputTotalsColumns>false</OutputTotalsColumns></CrossTab>