I'm using SelectedItems from a PivotControl to generate a chart.It turns out that when PivotColumns.Count == 1, the RowList of each element in SelectedItems can have up to 2 elements.
As you can see in the screenshot, when I set the pivot control to 3 PivotRows and 1 PivotColumns, the selected items are missing the value for the "State" dimension.
Those elements should read:
Column : Canada - Amount ; Row : Bike - Bike.FY 2005 - Bike - Bike.FY 2005.British Columbia ; Value : 4605600
Column : Canada - Amount ; Row : Bike - Bike.FY 2005 - Bike - Bike.FY 2005.Brunswick ; Value : 6063300
In code, you cannot either tell apart the value that belongs to "British Columbia" from the one that belongs to "Brunswick". If you inspect each item with the debugger, you'll see that it has only 2 elements in RowList instead of 3.
I made some tests and apparently this ONLY happens when there is only ONE PivotColumn. Apart from the sample in the screenshot, I also tried a case scenario with 4 PivotRows and 1 PivotColumn, and the items still get only 2 elements in the RowList collection instead of 4.
In the case of 1 PivotRow and 1 PivotColumn it works ok.
Thanks for your support.