2124724198576790
<pack :locale='2057' auto-extract='yes' class='excel-direct' cleaning='no' compat='no' dataRefreshTime='' ec-data-ts='2124724198160000' ec-logical-query='&lt;logical-query-extended-cache-key&gt;&#10;&lt;relation-xml&gt;&amp;lt;relations&amp;gt;&amp;#10;  &amp;lt;relation connection=&amp;apos;conn1&amp;apos;&amp;gt;&amp;#10;    &amp;lt;relation 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:Z16799:no:A1:Z16799: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;real&amp;apos; name=&amp;apos;Row&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;datetime&amp;apos; name=&amp;apos;Order Date&amp;apos; ordinal=&amp;apos;2&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Order&amp;apos; ordinal=&amp;apos;3&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Discount&amp;apos; ordinal=&amp;apos;4&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;5&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Order Quantity&amp;apos; ordinal=&amp;apos;6&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Sales&amp;apos; ordinal=&amp;apos;7&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Profit&amp;apos; ordinal=&amp;apos;8&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;9&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;10&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Department&amp;apos; ordinal=&amp;apos;11&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Container&amp;apos; ordinal=&amp;apos;12&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Category&amp;apos; ordinal=&amp;apos;13&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Item&amp;apos; ordinal=&amp;apos;14&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;15&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Customer_ID&amp;apos; ordinal=&amp;apos;16&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;17&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Region&amp;apos; ordinal=&amp;apos;18&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;State&amp;apos; ordinal=&amp;apos;19&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Country / Region&amp;apos; ordinal=&amp;apos;20&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;City&amp;apos; ordinal=&amp;apos;21&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Postal Code&amp;apos; ordinal=&amp;apos;22&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;datetime&amp;apos; name=&amp;apos;Ship Date&amp;apos; ordinal=&amp;apos;23&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;24&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;SubRegion&amp;apos; ordinal=&amp;apos;25&amp;apos; /&amp;gt;&amp;#10;      &amp;lt;/columns&amp;gt;&amp;#10;    &amp;lt;/relation&amp;gt;&amp;#10;    &amp;lt;is-not-distinct-join-semantics&amp;gt;false&amp;lt;/is-not-distinct-join-semantics&amp;gt;&amp;#10;  &amp;lt;/relation&amp;gt;&amp;#10;&amp;lt;/relations&amp;gt;&amp;#10;&lt;/relation-xml&gt;&#10;&lt;logical-query&gt;&#10;&lt;selects&gt;&#10;&lt;field&gt;[Customer Segment]&lt;/field&gt;&#10;&lt;field&gt;[Department]&lt;/field&gt;&#10;&lt;field&gt;[sum:Profit:ok]&lt;/field&gt;&#10;&lt;field&gt;[sum:Sales:ok]&lt;/field&gt;&#10;&lt;/selects&gt;&#10;&lt;projectOp class=&apos;logical-operator&apos;&gt;&#10;&lt;expressions&gt;&#10;&lt;binding name=&apos;[Customer Segment]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[Customer Segment]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[Department]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[Department]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;/expressions&gt;&#10;&lt;aggregateOp class=&apos;logical-operator&apos;&gt;&#10;&lt;measures&gt;&#10;&lt;binding name=&apos;[sum:Profit:ok]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;SUM&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[Profit]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[sum:Sales:ok]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;SUM&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[Sales]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;/measures&gt;&#10;&lt;groupbys&gt;&#10;&lt;binding name=&apos;[Customer Segment]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[Customer Segment]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[Department]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[Department]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;/groupbys&gt;&#10;&lt;relationOp class=&apos;logical-operator&apos; connection=&apos;conn1&apos; name=&apos;[Orders$]&apos;&gt;&#10;&lt;relation name=&apos;Orders$&apos; type=&apos;table&apos;&gt;&#10;&lt;attributes gridOrigin=&apos;A1:Z16799:no:A1:Z16799:0&apos; header=&apos;yes&apos; outcome=&apos;2&apos; /&gt;&#10;&lt;/relation&gt;&#10;&lt;cols&gt;&#10;&lt;/cols&gt;&#10;&lt;type&gt;&#10;&lt;schema&gt;&#10;&lt;field name=&apos;[Category]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[City]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Container]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Country / Region]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Customer Name]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Customer Segment]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Customer_ID]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Department]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Discount]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Item]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Order Date]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Order Priority]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Order Quantity]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Order]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Postal Code]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Product Base Margin]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Profit]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Region]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Row]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Sales]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Ship Date]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Ship Mode]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Shipping Cost]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[State]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[SubRegion]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Unit Price]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;/schema&gt;&#10;&lt;/type&gt;&#10;&lt;/relationOp&gt;&#10;&lt;/aggregateOp&gt;&#10;&lt;/projectOp&gt;&#10;&lt;/logical-query&gt;&#10;&lt;/logical-query-extended-cache-key&gt;&#10;' filename='Data/Data/Superstore Sales Training.xls' interpretationMode='0' is-single-table-union='yes' validate='no'>
</pack>
