L.2.9.3.3 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 
  <r>
    <x v="0"/>
    <s v="Pacific"/>
    <x v="0"/>
    <s v="Australia"/>
    <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="Australia"/>
    <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:

In the context of r:

Last updated on