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. Row Labels Claims Open Claims New Claims New Ind New Lit New Closed 1 20 3 0 0 0 1 2 33 0 0 0 0 0 3 483 16 6 0 0 8 4 990 32 8 1 0 7 5 1019 39 8 2 3 14 6 1120 57 20 3 0 18 7 1426 104 18 5 2 17 8 962 47 12 1 0 10 9 923 28 8 0 0 19 10 1354 114 14 5 4 18 Grand Total 8330 440 94 17 9 112 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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Exploding Pivot Data Issues

Thread starter edgallagher
Start date Jan 25, 2018
Tags

claims data exploding pivot table settings

edgallagher

New Member

Jan 25, 2018

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.

Row Labels	Claims	Open Claims	New Claims	New Ind	New Lit	New Closed
1	20	3	0	0	0	1
2	33	0	0	0	0	0
3	483	16	6	0	0	8
4	990	32	8	1	0	7
5	1019	39	8	2	3	14
6	1120	57	20	3	0	18
7	1426	104	18	5	2	17
8	962	47	12	1	0	10
9	923	28	8	0	0	19
10	1354	114	14	5	4	18
Grand Total	8330	440	94	17	9	112

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