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.