<pack class='dataengine' dbname='Data/UoY Tableau workbook_v12.twb Files/Union (Companies House).tde' 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;10.4&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.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&apos; /&gt;&#10;      &lt;output column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&apos; /&gt;&#10;      &lt;output column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[sum:Calculation_57139453334618119:ok]&apos; /&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[Action (SIC code (Renamed))]&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;[SIC code (Renamed)]&apos; /&gt;&#10;          &lt;/groupfilter&gt;&#10;          &lt;groupfilter function=&apos;member&apos; level=&apos;[SIC code (Renamed)]&apos; member=&apos;&amp;quot;Meat processing&amp;quot;&apos; user:ui-action-filter=&apos;[Action5]&apos; user:ui-domain=&apos;database&apos; user:ui-enumeration=&apos;inclusive&apos; user:ui-marker=&apos;enumerate&apos; /&gt;&#10;        &lt;/groupfilter&gt;&#10;      &lt;/filter&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[CompanyStatus]&apos;&gt;&#10;        &lt;groupfilter function=&apos;union&apos; user:ui-domain=&apos;relevant&apos; user:ui-enumeration=&apos;inclusive&apos; user:ui-marker=&apos;enumerate&apos;&gt;&#10;          &lt;groupfilter function=&apos;member&apos; level=&apos;[CompanyStatus]&apos; member=&apos;%null%&apos; /&gt;&#10;          &lt;groupfilter function=&apos;member&apos; level=&apos;[CompanyStatus]&apos; member=&apos;&amp;quot;Active&amp;quot;&apos; /&gt;&#10;        &lt;/groupfilter&gt;&#10;      &lt;/filter&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&apos;&gt;&#10;        &lt;groupfilter function=&apos;union&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;[SIC code]&apos; member=&apos;%null%&apos; /&gt;&#10;          &lt;groupfilter from=&apos;&amp;quot;0123 - Farming of swine&amp;quot;&apos; function=&apos;range&apos; level=&apos;[SIC code]&apos; to=&apos;&amp;quot;1598 - Produce mineral water, soft drinks&amp;quot;&apos; /&gt;&#10;        &lt;/groupfilter&gt;&#10;      &lt;/filter&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[gov Area]&apos;&gt;&#10;        &lt;groupfilter from=&apos;&amp;quot;Humber&amp;quot;&apos; function=&apos;range&apos; level=&apos;[gov Area]&apos; to=&apos;&amp;quot;York, North Yorkshire and East Riding&amp;quot;&apos; user:ui-domain=&apos;database&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 name=&amp;apos;Extract&amp;apos; table=&amp;apos;[Extract].[Extract]&amp;apos; type=&amp;apos;table&amp;apos; /&amp;gt;&amp;#10;&lt;/relation-xml&gt;&#10;  &lt;relation-names&gt;&#10;    &lt;relation-name key=&apos;[Calculation_788692917129379842]&apos; value=&apos;[Extract].[Calculation_788692917129379842]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Calculation_788692917129564163]&apos; value=&apos;[Extract].[Calculation_788692917129564163]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Calculation_788692917129715716]&apos; value=&apos;[Extract].[Calculation_788692917129715716]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Company Name]&apos; value=&apos;[Extract].[Company Name]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[CompanyStatus]&apos; value=&apos;[Extract].[CompanyStatus]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Country]&apos; value=&apos;[Extract].[Country]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[EWC DESCRIPTION]&apos; value=&apos;[Extract].[EWC DESCRIPTION]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[EWC ID]&apos; value=&apos;[Extract].[EWC ID]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[EWC of Interest]&apos; value=&apos;[Extract].[EWC of Interest]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Latitude]&apos; value=&apos;[Extract].[Latitude]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Local Authority]&apos; value=&apos;[Extract].[Local Authority]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Longitude]&apos; value=&apos;[Extract].[Longitude]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Number of Records]&apos; value=&apos;[Extract].[Number of Records]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[ONS Code (New)]&apos; value=&apos;[Extract].[ONS Code (New)]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[ONS Code (Old)]&apos; value=&apos;[Extract].[ONS Code (Old)]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Operator]&apos; value=&apos;[Extract].[Operator]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Permit Type of interest]&apos; value=&apos;[Extract].[Permit Type of interest]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Permit Type renamed]&apos; value=&apos;[Extract].[Permit Type renamed]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[PointID]&apos; value=&apos;[Extract].[PointID]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[PolygonID]&apos; value=&apos;[Extract].[PolygonID]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Postcode Area]&apos; value=&apos;[Extract].[Postcode Area]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Postcode]&apos; value=&apos;[Extract].[Postcode]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[QUANTITY RELEASED (Tonnes)]&apos; value=&apos;[Extract].[QUANTITY RELEASED (Tonnes)]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[SIC code (Renamed)]&apos; value=&apos;[Extract].[SIC code (Renamed)]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[SIC code]&apos; value=&apos;[Extract].[SIC code]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Sheet]&apos; value=&apos;[Extract].[Sheet]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Site Type 1]&apos; value=&apos;[Extract].[Site Type 1]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Site Type]&apos; value=&apos;[Extract].[Site Type]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Source]&apos; value=&apos;[Extract].[Source]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[SubPolygonID]&apos; value=&apos;[Extract].[SubPolygonID]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Table Name]&apos; value=&apos;[Extract].[Table Name]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Tonnes Received]&apos; value=&apos;[Extract].[Tonnes Received]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[gov Area]&apos; value=&apos;[Extract].[gov Area]&apos; /&gt;&#10;  &lt;/relation-names&gt;&#10;  &lt;bindings&gt;&#10;    &lt;binding key=&apos;[SIC code]&apos; value=&apos;SIC code&apos; /&gt;&#10;    &lt;binding key=&apos;[sum:Calculation_57139453334618119:ok]&apos; value=&apos;sum:Calculation_57139453334618119:ok&apos; /&gt;&#10;  &lt;/bindings&gt;&#10;  &lt;lod&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&lt;/column&gt;&#10;  &lt;/lod&gt;&#10;  &lt;measure-filter-lod&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&lt;/column&gt;&#10;  &lt;/measure-filter-lod&gt;&#10;  &lt;output&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&lt;/column&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[sum:Calculation_57139453334618119:ok]&lt;/column&gt;&#10;  &lt;/output&gt;&#10;  &lt;aggregates /&gt;&#10;  &lt;slicers&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[Action (SIC code (Renamed))]&lt;/column&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[CompanyStatus]&lt;/column&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[gov Area]&lt;/column&gt;&#10;  &lt;/slicers&gt;&#10;  &lt;filtered&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&lt;/column&gt;&#10;  &lt;/filtered&gt;&#10;  &lt;local-filters&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[Action (SIC code (Renamed))]&lt;/column&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[CompanyStatus]&lt;/column&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&lt;/column&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[gov Area]&lt;/column&gt;&#10;  &lt;/local-filters&gt;&#10;  &lt;unnamed-calcs&gt;&#10;    &lt;column&gt;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[sum:Calculation_57139453334618119:ok]&lt;/column&gt;&#10;  &lt;/unnamed-calcs&gt;&#10;  &lt;calculations&gt;&#10;    &lt;calculation column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[CompanyStatus]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code (Renamed)]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[gov Area]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[sum:Calculation_57139453334618119:ok]&apos; formula=&apos;SUM(IF [CompanyStatus] == &amp;quot;Active&amp;quot; THEN 1 ELSE NULL END)&apos; /&gt;&#10;  &lt;/calculations&gt;&#10;  &lt;agg-types&gt;&#10;    &lt;agg-type column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&apos; type=&apos;None&apos; /&gt;&#10;    &lt;agg-type column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[sum:Calculation_57139453334618119:ok]&apos; type=&apos;Sum&apos; /&gt;&#10;  &lt;/agg-types&gt;&#10;  &lt;data-types&gt;&#10;    &lt;data-type column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[CompanyStatus]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code (Renamed)]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[SIC code]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[gov Area]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.1m96yp71tb58fk11jmjjp0p9hh4n].[sum:Calculation_57139453334618119: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='2123882746170000' schema='Extract' tablename='Extract'>
</pack>
