XML - pivotCacheRecords part
This part expresses the underlying source data that the PivotTable is aggregating. (Note that the data has been trimmed down to two records to increase readability.)
<pivotCacheRecords … xmlns:r="…" count="2"> <r> <x v="0"/> <s v="Pacific"/> <x v="0"/> <s v=""/> <x v="0"/> <x v="0"/> <s v="3550"/> <x v="0"/> <x v="0"/> <s v="Road-150 Red, 62"/> <s v="This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control."/> <s v="No Discount"/> <s v="No Discount"/> <s v="No Discount"/> <x v="0"/> <x v="0"/> <x v="0"/> <s v="Australian Dollar"/> <n v="1"/> <n v="3578.27"/> <n v="3578.27"/> <n v="0"/> <n v="0"/> <n v="2171.2941999999998"/> <n v="2171.2941999999998"/> <n v="3578.27"/> <n v="286.26159999999999"/> <n v="89.456800000000001"/> </r> <r> <x v="1"/> <s v="Pacific"/> <x v="0"/> <s v=""/> <x v="0"/> <x v="0"/> <s v="3550"/> <x v="0"/> <x v="0"/> <s v="Road-150 Red, 44"/> <s v="This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control."/> <s v="No Discount"/> <s v="No Discount"/> <s v="No Discount"/> <x v="0"/> <x v="0"/> <x v="1"/> <s v="Australian Dollar"/> <n v="1"/> <n v="3578.27"/> <n v="3578.27"/> <n v="0"/> <n v="0"/> <n v="2171.2941999999998"/> <n v="2171.2941999999998"/> <n v="3578.27"/> <n v="286.26159999999999"/> <n v="89.456800000000001"/> </r> </pivotCacheRecords>
In the context of <pivotCacheRecords>
:
<r>
contains one record.
In the context of <r>
:
@x
is an index value referencing an item for this field, as defined in the pivotCacheDefinition part.@s
indicates that a value is being expressed inline in this record, and it is a string value.@n
indicates that a value is being expressed inline in this record, and it is a numeric value.