L.2.9.3.2 XML - pivotCacheDefinition part
The pivotCacheDefinition part defines each field in the source data, including the name, the string resources of the instance data (for shared items), and information about the type of data appearing in the field. Note: some of the “Customer Name” and “City” values have been removed to improve readability and reduce length.
<pivotCacheDefinition xmlns:r="…" r:id="rId1" refreshedBy="AnonUser"
refreshedDateIso="2006-05-22T10:07:16" createdVersion="3"
refreshedVersion="3" minRefreshableVersion="3" recordCount="182">
<cacheSource type="worksheet">
<worksheetSource name="Table1"/>
</cacheSource>
<cacheFields count="28">
<cacheField name="Customer Name" numFmtId="0">
<sharedItems count="7">
<s v="Michele Raman"/>
<s v="Misty Raji"/>
<s v="Tabitha E Arthur"/>
<s v="Clarence D Rai"/>
<s v="Jimmy L Moreno"/>
<s v="Rob Verhoff"/>
<s v="Levi Sai"/>
</sharedItems>
</cacheField>
<cacheField name="Group" numFmtId="0">
<sharedItems/>
</cacheField>
<cacheField name="Country" numFmtId="0">
<sharedItems count="1">
<s v="Australia"/>
</sharedItems>
</cacheField>
<cacheField name="Region" numFmtId="0">
<sharedItems/>
</cacheField>
<cacheField name="State" numFmtId="0">
<sharedItems count="5">
<s v="Victoria"/>
<s v="Queensland"/>
<s v="South Australia"/>
<s v="New South Wales"/>
<s v="Tasmania"/>
</sharedItems>
</cacheField>
<cacheField name="City" numFmtId="0">
<sharedItems count="7">
<s v="Bendigo"/>
<s v="Brisbane"/>
<s v="Caloundra"/>
<s v="Cloverdale"/>
<s v="Coffs Harbour"/>
<s v="Cranbourne"/>
<s v="Darlinghurst"/>
</sharedItems>
</cacheField>
<cacheField name="Postal Code" numFmtId="0">
<sharedItems/>
</cacheField>
<cacheField name="Product Category" numFmtId="0">
<sharedItems count="1">
<s v="Bikes"/>
</sharedItems>
</cacheField>
<cacheField name="Product Subcategory" numFmtId="0">
<sharedItems count="2">
<s v="Road Bikes"/>
<s v="Mountain Bikes"/>
</sharedItems>
</cacheField>
<cacheField name="Product Name" numFmtId="0">
<sharedItems/>
</cacheField>
<cacheField name="Product Description" numFmtId="0">
<sharedItems/>
</cacheField>
<cacheField name="Promotion Category" numFmtId="0">
<sharedItems/>
</cacheField>
<cacheField name="Promotion" numFmtId="0">
<sharedItems/>
</cacheField>
<cacheField name="Promotion Type" numFmtId="0">
<sharedItems/>
</cacheField>
<cacheField name="Year" numFmtId="0">
<sharedItems count="1">
<s v="2001"/>
</sharedItems>
</cacheField>
<cacheField name="Quarter" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" containsInteger="1" minValue="3" maxValue="3"
count="1">
<n v="3"/>
</sharedItems>
</cacheField>
<cacheField name="Month" numFmtId="0">
<sharedItems count="3">
<s v="September"/>
<s v="July"/>
<s v="August"/>
</sharedItems>
</cacheField>
<cacheField name="Currency" numFmtId="0">
<sharedItems/>
</cacheField>
<cacheField name="Order Quantity" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" containsInteger="1" minValue="1"
maxValue="1"/>
</cacheField>
<cacheField name="Unit Price" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" minValue="699.09820000000002"
maxValue="3578.27"/>
</cacheField>
<cacheField name="Extended Amount" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" minValue="699.09820000000002"
maxValue="3578.27"/>
</cacheField>
<cacheField name="Discount Pct" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" containsInteger="1" minValue="0"
maxValue="0"/>
</cacheField>
<cacheField name="Discount Amount" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" containsInteger="1" minValue="0"
maxValue="0"/>
</cacheField>
<cacheField name="Product Standard Cost" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" minValue="413.1463"
maxValue="2171.2941999999998"/>
</cacheField>
<cacheField name="Total Product Cost" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" minValue="413.1463"
maxValue="2171.2941999999998"/>
</cacheField>
<cacheField name="Sales Amount" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" minValue="699.09820000000002"
maxValue="3578.27"/>
</cacheField>
<cacheField name="Tax Amount" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1"
minValue="55.927900000000001" maxValue="286.26159999999999"/>
</cacheField>
<cacheField name="Freight" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0"
containsNumber="1" minValue="17.477499999999999"
maxValue="89.456800000000001"/>
</cacheField>
</cacheFields>
</pivotCacheDefinition>In the context of pivotCacheDefinition:
In the context of cacheSource:
In the context of cacheFields, which is a collection of all the field definitions in the source data:
In the context of cacheField:
In the context of sharedItems:
If there are no shared items expressed for a particular field, then the values are expressed directly in the pivotCacheRecords part.
Items in the PivotCacheDefinition can be shared, in order to reduce the redundancy of those values, since they’re referenced in multiple places across all the PivotTable parts. For example, a value might be part of a filter, it might appear on a row or column axis, and appears in the pivotCacheRecords definition as well. However, because of the performance cost of creating the optimized shared items, items are only shared if they are actually in use in the PivotTable. Therefore, depending on user actions on the PivotTable layout, the pivotCacheDefinition and underlying PivotCacheRecords part can be updated.