Exploding Pivot Data Issues

[edgallagher]

Hi there,

Recent issue I've noticed in pivot tables in Excel 2013. When I go to explode data I am getting different results than I want.


[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl106, width: 64"]Row Labels[/TD]
[TD="class: xl106, width: 64"]Claims[/TD]
[TD="class: xl106, width: 64"]Open Claims[/TD]
[TD="class: xl106, width: 64"]New Claims[/TD]
[TD="class: xl106, width: 64"]New Ind[/TD]
[TD="class: xl106, width: 64"]New Lit [/TD]
[TD="class: xl106, width: 64"]New Closed [/TD]
[/TR]
[TR]
[TD="class: xl107"]1[/TD]
[TD="class: xl107"]20[/TD]
[TD="class: xl107"]3[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]1[/TD]
[/TR]
[TR]
[TD="class: xl107"]2[/TD]
[TD="class: xl107"]33[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]0[/TD]
[/TR]
[TR]
[TD="class: xl107"]3[/TD]
[TD="class: xl107"]483[/TD]
[TD="class: xl107"]16[/TD]
[TD="class: xl107"]6[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]8[/TD]
[/TR]
[TR]
[TD="class: xl107"]4[/TD]
[TD="class: xl107"]990[/TD]
[TD="class: xl107"]32[/TD]
[TD="class: xl107"]8[/TD]
[TD="class: xl107"]1[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]7[/TD]
[/TR]
[TR]
[TD="class: xl107"]5[/TD]
[TD="class: xl107"]1019[/TD]
[TD="class: xl107"]39[/TD]
[TD="class: xl107"]8[/TD]
[TD="class: xl107"]2[/TD]
[TD="class: xl107"]3[/TD]
[TD="class: xl107"]14[/TD]
[/TR]
[TR]
[TD="class: xl107"]6[/TD]
[TD="class: xl107"]1120[/TD]
[TD="class: xl107"]57[/TD]
[TD="class: xl107"]20[/TD]
[TD="class: xl107"]3[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]18[/TD]
[/TR]
[TR]
[TD="class: xl107"]7[/TD]
[TD="class: xl107"]1426[/TD]
[TD="class: xl107"]104[/TD]
[TD="class: xl107"]18[/TD]
[TD="class: xl107"]5[/TD]
[TD="class: xl107"]2[/TD]
[TD="class: xl107"]17[/TD]
[/TR]
[TR]
[TD="class: xl107"]8[/TD]
[TD="class: xl107"]962[/TD]
[TD="class: xl107"]47[/TD]
[TD="class: xl107"]12[/TD]
[TD="class: xl107"]1[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]10[/TD]
[/TR]
[TR]
[TD="class: xl107"]9[/TD]
[TD="class: xl107"]923[/TD]
[TD="class: xl107"]28[/TD]
[TD="class: xl107"]8[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]0[/TD]
[TD="class: xl107"]19[/TD]
[/TR]
[TR]
[TD="class: xl107"]10[/TD]
[TD="class: xl107"]1354[/TD]
[TD="class: xl107"]114[/TD]
[TD="class: xl107"]14[/TD]
[TD="class: xl107"]5[/TD]
[TD="class: xl107"]4[/TD]
[TD="class: xl107"]18[/TD]
[/TR]
[TR]
[TD="class: xl106"]Grand Total[/TD]
[TD="class: xl106"]8330[/TD]
[TD="class: xl106"]440[/TD]
[TD="class: xl106"]94[/TD]
[TD="class: xl106"]17[/TD]
[TD="class: xl106"]9[/TD]
[TD="class: xl106"]112[/TD]
[/TR]
</tbody>[/TABLE]


The data getting exploded seems default to certain rows. If I double click on 17 (new Ind total) i get all 8330 rows. The result is the same if I remove that piece of data. If I clock on the Row 1, new closed (1 item) i get all 20 claims from row one.

Is it the size of my data or did I throw a switch somewhere without realizing it?

Thanks in advance!

Ed