<pack :locale='1033' class='excel-direct' cleaning='no' compat='no' dataRefreshTime='' ec-abstract-query='&lt;aq-cache-key are-all-local-sorts-supported=&apos;true&apos; has-agg-measure-filters=&apos;false&apos; has-lod-calcs=&apos;false&apos; has-user-reference=&apos;false&apos; ind-join-semantics=&apos;false&apos; start-of-week=&apos;sunday&apos; version=&apos;18.1&apos;&gt;&#10;  &lt;query aggregation=&apos;true&apos; caching=&apos;normal&apos; hierarchize-rows=&apos;false&apos; include-empty=&apos;false&apos;&gt;&#10;    &lt;fields&gt;&#10;      &lt;field column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Customer Segment]&apos; /&gt;&#10;      &lt;field column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Ship Mode]&apos; /&gt;&#10;      &lt;output column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Customer Segment]&apos; /&gt;&#10;      &lt;output column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Ship Mode]&apos; /&gt;&#10;      &lt;output column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[sum:Sales:ok]&apos; /&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Action (Customer Segment,YEAR(Order Date))]&apos;&gt;&#10;        &lt;groupfilter function=&apos;intersection&apos;&gt;&#10;          &lt;groupfilter function=&apos;crossjoin&apos;&gt;&#10;            &lt;groupfilter function=&apos;level-members&apos; level=&apos;[Customer Segment]&apos; /&gt;&#10;            &lt;groupfilter function=&apos;level-members&apos; level=&apos;[yr:Order Date:ok]&apos; /&gt;&#10;          &lt;/groupfilter&gt;&#10;          &lt;groupfilter function=&apos;crossjoin&apos; user:ui-action-filter=&apos;[Action1]&apos; user:ui-domain=&apos;database&apos; user:ui-enumeration=&apos;inclusive&apos; user:ui-marker=&apos;enumerate&apos;&gt;&#10;            &lt;groupfilter function=&apos;member&apos; level=&apos;[Customer Segment]&apos; member=&apos;&amp;quot;Corporate&amp;quot;&apos; /&gt;&#10;            &lt;groupfilter function=&apos;member&apos; level=&apos;[yr:Order Date:ok]&apos; member=&apos;2010&apos; /&gt;&#10;          &lt;/groupfilter&gt;&#10;        &lt;/groupfilter&gt;&#10;      &lt;/filter&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[my:Order Date:ok]&apos;&gt;&#10;        &lt;groupfilter from=&apos;201001&apos; function=&apos;range&apos; level=&apos;[my:Order Date:ok]&apos; to=&apos;201312&apos; user:ui-domain=&apos;relevant&apos; user:ui-enumeration=&apos;inclusive&apos; user:ui-marker=&apos;enumerate&apos; /&gt;&#10;      &lt;/filter&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[yr:Order Date:ok]&apos;&gt;&#10;        &lt;groupfilter from=&apos;2010&apos; function=&apos;range&apos; level=&apos;[yr:Order Date:ok]&apos; to=&apos;2013&apos; user:ui-domain=&apos;relevant&apos; user:ui-enumeration=&apos;inclusive&apos; user:ui-marker=&apos;enumerate&apos; /&gt;&#10;      &lt;/filter&gt;&#10;    &lt;/fields&gt;&#10;  &lt;/query&gt;&#10;  &lt;relation-xml&gt;&amp;lt;relation connection=&amp;apos;excel-direct.05qtnux1uzs31y1e9uqdx0fejw2d&amp;apos; name=&amp;apos;Orders&amp;apos; table=&amp;apos;[Orders$]&amp;apos; type=&amp;apos;table&amp;apos;&amp;gt;&amp;#10;  &amp;lt;columns gridOrigin=&amp;apos;A1:X9427:no:A1:X9427:0&amp;apos; header=&amp;apos;yes&amp;apos; outcome=&amp;apos;2&amp;apos;&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;integer&amp;apos; name=&amp;apos;Row ID&amp;apos; ordinal=&amp;apos;0&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Order Priority&amp;apos; ordinal=&amp;apos;1&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Discount&amp;apos; ordinal=&amp;apos;2&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Unit Price&amp;apos; ordinal=&amp;apos;3&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Shipping Cost&amp;apos; ordinal=&amp;apos;4&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;integer&amp;apos; name=&amp;apos;Customer ID&amp;apos; ordinal=&amp;apos;5&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Customer Name&amp;apos; ordinal=&amp;apos;6&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Ship Mode&amp;apos; ordinal=&amp;apos;7&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Customer Segment&amp;apos; ordinal=&amp;apos;8&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Product Category&amp;apos; ordinal=&amp;apos;9&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Product Sub-Category&amp;apos; ordinal=&amp;apos;10&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Product Container&amp;apos; ordinal=&amp;apos;11&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Product Name&amp;apos; ordinal=&amp;apos;12&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Product Base Margin&amp;apos; ordinal=&amp;apos;13&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Region&amp;apos; ordinal=&amp;apos;14&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;State or Province&amp;apos; ordinal=&amp;apos;15&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;City&amp;apos; ordinal=&amp;apos;16&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;integer&amp;apos; name=&amp;apos;Postal Code&amp;apos; ordinal=&amp;apos;17&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;date&amp;apos; name=&amp;apos;Order Date&amp;apos; ordinal=&amp;apos;18&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;date&amp;apos; name=&amp;apos;Ship Date&amp;apos; ordinal=&amp;apos;19&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Profit&amp;apos; ordinal=&amp;apos;20&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;integer&amp;apos; name=&amp;apos;Quantity ordered new&amp;apos; ordinal=&amp;apos;21&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Sales&amp;apos; ordinal=&amp;apos;22&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;column datatype=&amp;apos;integer&amp;apos; name=&amp;apos;Order ID&amp;apos; ordinal=&amp;apos;23&amp;apos; /&amp;gt;&amp;#10;  &amp;lt;/columns&amp;gt;&amp;#10;&amp;lt;/relation&amp;gt;&amp;#10;&lt;/relation-xml&gt;&#10;  &lt;relation-names&gt;&#10;    &lt;relation-name key=&apos;[City]&apos; value=&apos;[Orders].[City]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Customer ID]&apos; value=&apos;[Orders].[Customer ID]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Customer Name]&apos; value=&apos;[Orders].[Customer Name]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Customer Segment]&apos; value=&apos;[Orders].[Customer Segment]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Discount]&apos; value=&apos;[Orders].[Discount]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Order Date]&apos; value=&apos;[Orders].[Order Date]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Order ID]&apos; value=&apos;[Orders].[Order ID]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Order Priority]&apos; value=&apos;[Orders].[Order Priority]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Postal Code]&apos; value=&apos;[Orders].[Postal Code]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Product Base Margin]&apos; value=&apos;[Orders].[Product Base Margin]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Product Category]&apos; value=&apos;[Orders].[Product Category]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Product Container]&apos; value=&apos;[Orders].[Product Container]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Product Name]&apos; value=&apos;[Orders].[Product Name]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Product Sub-Category]&apos; value=&apos;[Orders].[Product Sub-Category]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Profit]&apos; value=&apos;[Orders].[Profit]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Quantity ordered new]&apos; value=&apos;[Orders].[Quantity ordered new]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Region]&apos; value=&apos;[Orders].[Region]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Row ID]&apos; value=&apos;[Orders].[Row ID]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Sales]&apos; value=&apos;[Orders].[Sales]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Ship Date]&apos; value=&apos;[Orders].[Ship Date]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Ship Mode]&apos; value=&apos;[Orders].[Ship Mode]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Shipping Cost]&apos; value=&apos;[Orders].[Shipping Cost]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[State or Province]&apos; value=&apos;[Orders].[State or Province]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Unit Price]&apos; value=&apos;[Orders].[Unit Price]&apos; /&gt;&#10;  &lt;/relation-names&gt;&#10;  &lt;bindings&gt;&#10;    &lt;binding key=&apos;[Customer Segment]&apos; value=&apos;Customer Segment&apos; /&gt;&#10;    &lt;binding key=&apos;[Ship Mode]&apos; value=&apos;Ship Mode&apos; /&gt;&#10;    &lt;binding key=&apos;[sum:Sales:ok]&apos; value=&apos;sum:Sales:ok&apos; /&gt;&#10;  &lt;/bindings&gt;&#10;  &lt;lod&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Customer Segment]&lt;/column&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Ship Mode]&lt;/column&gt;&#10;  &lt;/lod&gt;&#10;  &lt;measure-filter-lod&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Customer Segment]&lt;/column&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Ship Mode]&lt;/column&gt;&#10;  &lt;/measure-filter-lod&gt;&#10;  &lt;output&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Customer Segment]&lt;/column&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Ship Mode]&lt;/column&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[sum:Sales:ok]&lt;/column&gt;&#10;  &lt;/output&gt;&#10;  &lt;aggregates /&gt;&#10;  &lt;slicers&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Action (Customer Segment,YEAR(Order Date))]&lt;/column&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[my:Order Date:ok]&lt;/column&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[yr:Order Date:ok]&lt;/column&gt;&#10;  &lt;/slicers&gt;&#10;  &lt;filtered /&gt;&#10;  &lt;local-filters&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Action (Customer Segment,YEAR(Order Date))]&lt;/column&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[my:Order Date:ok]&lt;/column&gt;&#10;    &lt;column&gt;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[yr:Order Date:ok]&lt;/column&gt;&#10;  &lt;/local-filters&gt;&#10;  &lt;unnamed-calcs /&gt;&#10;  &lt;calculations&gt;&#10;    &lt;calculation column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Customer Segment]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Order Date]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Sales]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Ship Mode]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[my:Order Date:ok]&apos; formula=&apos;(DATEPART(&amp;apos;year&amp;apos;, [Order Date])*100 + DATEPART(&amp;apos;month&amp;apos;, [Order Date]))&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[sum:Sales:ok]&apos; formula=&apos;SUM([Sales])&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[yr:Order Date:ok]&apos; formula=&apos;DATEPART(&amp;apos;year&amp;apos;, [Order Date])&apos; /&gt;&#10;  &lt;/calculations&gt;&#10;  &lt;agg-types&gt;&#10;    &lt;agg-type column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Customer Segment]&apos; type=&apos;None&apos; /&gt;&#10;    &lt;agg-type column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Ship Mode]&apos; type=&apos;None&apos; /&gt;&#10;    &lt;agg-type column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[sum:Sales:ok]&apos; type=&apos;Sum&apos; /&gt;&#10;  &lt;/agg-types&gt;&#10;  &lt;data-types&gt;&#10;    &lt;data-type column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Customer Segment]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Order Date]&apos; type=&apos;date&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Sales]&apos; type=&apos;real&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[Ship Mode]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[my:Order Date:ok]&apos; type=&apos;integer&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[sum:Sales:ok]&apos; type=&apos;real&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.17ib4j70ncuvbb1gr4bb21o2f8ga].[yr:Order Date:ok]&apos; type=&apos;integer&apos; /&gt;&#10;  &lt;/data-types&gt;&#10;  &lt;current-user display-name=&apos;&apos; name=&apos;&apos; short-domain-qualified-name=&apos;&apos; type=&apos;user&apos; /&gt;&#10;&lt;/aq-cache-key&gt;&#10;' ec-data-ts='2124043329530000' filename='Data/Calculations - done/Sample-Superstore.xlsx' interpretationMode='0' is-single-table-union='yes' server='' validate='no'>
</pack>
