Hello, I wonder if anyone can help with a pivot table issue I'm having.
I've created a pivot table and am trying to group the rows on the far left column such that the numbers between 1-1,9 are grouped together, 2-2.9 are grouped together, 3-3.9 are grouped together etc. (Ideally I would like to do this first for each campaign and then do the same combining all campaigns.)
<colgroup><col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> </colgroup><tbody>
[TD="class: xl65, width: 92"]Campaign 1[/TD]
[TD="width: 82, align: right"]30356[/TD]
[TD="class: xl67"]1.00[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl67"]1.10[/TD]
[TD="align: right"]2265[/TD]
[TD="class: xl67"]1.30[/TD]
[TD="align: right"]114[/TD]
[TD="class: xl67"]1.40[/TD]
[TD="align: right"]1264[/TD]
[TD="class: xl67"]1.50[/TD]
[TD="align: right"]3898[/TD]
[TD="class: xl67"]1.60[/TD]
[TD="align: right"]3672[/TD]
[TD="class: xl67"]1.70[/TD]
[TD="align: right"]1246[/TD]
[TD="class: xl67"]1.80[/TD]
[TD="align: right"]2160[/TD]
[TD="class: xl67"]1.90[/TD]
[TD="align: right"]1453[/TD]
[TD="class: xl67"]2.00[/TD]
[TD="align: right"]1356[/TD]
[TD="class: xl67"]2.20[/TD]
[TD="align: right"]1312[/TD]
[TD="class: xl67"]2.30[/TD]
[TD="align: right"]362[/TD]
[TD="class: xl67"]2.40[/TD]
[TD="align: right"]1337[/TD]
[TD="class: xl67"]2.50[/TD]
[TD="align: right"]162[/TD]
[TD="class: xl67"]2.60[/TD]
[TD="align: right"]356[/TD]
[TD="class: xl67"]2.70[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl67"]2.80[/TD]
[TD="align: right"]119[/TD]
[TD="class: xl67"]2.90[/TD]
[TD="align: right"]144[/TD]
[TD="class: xl67"]3.00[/TD]
[TD="align: right"]153[/TD]
[TD="class: xl67"]3.10[/TD]
[TD="align: right"]167[/TD]
[TD="class: xl67"]3.30[/TD]
[TD="align: right"]69[/TD]
[TD="class: xl67"]3.40[/TD]
[TD="align: right"]53[/TD]
[TD="class: xl67"]3.50[/TD]
[TD="align: right"]1950[/TD]
[TD="class: xl67"]3.60[/TD]
[TD="align: right"]193[/TD]
[TD="class: xl67"]3.70[/TD]
[TD="align: right"]197[/TD]
[TD="class: xl67"]4.00[/TD]
[TD="align: right"]2102[/TD]
[TD="class: xl67"]4.10[/TD]
[TD="align: right"]1042[/TD]
[TD="class: xl67"]4.20[/TD]
[TD="align: right"]1804[/TD]
[TD="class: xl67"]4.50[/TD]
[TD="align: right"]1307[/TD]
[TD="class: xl65"]Campaign 2[/TD]
[TD="align: right"]7663[/TD]
[TD="class: xl66"]1.1[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]37[/TD]
[TD="class: xl66"]1.9[/TD]
[TD="align: right"]430[/TD]
[TD="class: xl66"]2[/TD]
[TD="align: right"]177[/TD]
[TD="class: xl66"]2.2[/TD]
[TD="align: right"]435[/TD]
[TD="class: xl66"]2.3[/TD]
[TD="align: right"]382[/TD]
[TD="class: xl66"]2.4[/TD]
[TD="align: right"]367[/TD]
[TD="class: xl66"]2.5[/TD]
[TD="align: right"]263[/TD]
[TD="class: xl66"]2.9[/TD]
[TD="align: right"]1586[/TD]
[TD="class: xl66"]3[/TD]
[TD="align: right"]1148[/TD]
[TD="class: xl66"]3.1[/TD]
[TD="align: right"]13[/TD]
[TD="class: xl66"]3.2[/TD]
[TD="align: right"]35[/TD]
[TD="class: xl66"]3.3[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl66"]3.8[/TD]
[TD="align: right"]142[/TD]
[TD="class: xl66"]3.9[/TD]
[TD="align: right"]396[/TD]
[TD="class: xl66"]4[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]4.1[/TD]
[TD="align: right"]706[/TD]
[TD="class: xl66"]4.2[/TD]
[TD="align: right"]283[/TD]
[TD="class: xl66"]4.3[/TD]
[TD="align: right"]269[/TD]
[TD="class: xl66"]4.4[/TD]
[TD="align: right"]346[/TD]
[TD="class: xl66"]4.6[/TD]
[TD="align: right"]269[/TD]
[TD="class: xl66"]5[/TD]
[TD="align: right"]279[/TD]
[TD="class: xl66"]5.1[/TD]
[TD="align: right"]16[/TD]
[TD="class: xl66"]5.7[/TD]
[TD="align: right"]7[/TD]
[TD="class: xl66"]5.9[/TD]
[TD="align: right"]14[/TD]
[TD="class: xl66"]6.1[/TD]
[TD="align: right"]40[/TD]
[TD="class: xl66"]6.2[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl65"]Campaign 3[/TD]
[TD="align: right"]1042[/TD]
[TD="class: xl66"]1[/TD]
[TD="align: right"]465[/TD]
[TD="class: xl66"]1.1[/TD]
[TD="align: right"]232[/TD]
[TD="class: xl66"]1.2[/TD]
[TD="align: right"]105[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]240[/TD]
[TD="class: xl65"]Campaign 4[/TD]
[TD="align: right"]6311[/TD]
[TD="class: xl66"]1[/TD]
[TD="align: right"]2458[/TD]
[TD="class: xl66"]1.1[/TD]
[TD="align: right"]78[/TD]
[TD="class: xl66"]1.2[/TD]
[TD="align: right"]120[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]313[/TD]
[TD="class: xl66"]1.4[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]1.9[/TD]
[TD="align: right"]274[/TD]
[TD="class: xl66"]2[/TD]
[TD="align: right"]26[/TD]
[TD="class: xl66"]2.1[/TD]
[TD="align: right"]278[/TD]
[TD="class: xl66"]2.2[/TD]
[TD="align: right"]540[/TD]
[TD="class: xl66"]2.3[/TD]
[TD="align: right"]46[/TD]
[TD="class: xl66"]2.4[/TD]
[TD="align: right"]515[/TD]
[TD="class: xl66"]2.5[/TD]
[TD="align: right"]17[/TD]
[TD="class: xl66"]2.7[/TD]
[TD="align: right"]396[/TD]
[TD="class: xl66"]3.4[/TD]
[TD="align: right"]137[/TD]
[TD="class: xl66"]3.6[/TD]
[TD="align: right"]259[/TD]
[TD="class: xl66"]3.7[/TD]
[TD="align: right"]183[/TD]
[TD="class: xl66"]3.8[/TD]
[TD="align: right"]211[/TD]
[TD="class: xl66"]3.9[/TD]
[TD="align: right"]104[/TD]
[TD="class: xl66"]4.2[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]4.4[/TD]
[TD="align: right"]193[/TD]
[TD="class: xl66"]4.9[/TD]
[TD="align: right"]15[/TD]
[TD="class: xl66"]5[/TD]
[TD="align: right"]118[/TD]
[TD="class: xl66"]5.2[/TD]
[TD="align: right"]12[/TD]
[TD="class: xl66"]5.7[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl66"]5.8[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]--[/TD]
[TD="align: right"]0[/TD]
[TD="class: xl65"]Campaign 5[/TD]
[TD="align: right"]2562[/TD]
[TD="class: xl66"]1[/TD]
[TD="align: right"]800[/TD]
[TD="class: xl66"]1.2[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]1.6[/TD]
[TD="align: right"]220[/TD]
[TD="class: xl66"]1.7[/TD]
[TD="align: right"]12[/TD]
[TD="class: xl66"]1.8[/TD]
[TD="align: right"]101[/TD]
[TD="class: xl66"]1.9[/TD]
[TD="align: right"]351[/TD]
[TD="class: xl66"]2[/TD]
[TD="align: right"]481[/TD]
[TD="class: xl66"]2.1[/TD]
[TD="align: right"]477[/TD]
[TD="class: xl66"]2.2[/TD]
[TD="align: right"]18[/TD]
[TD="class: xl66"]2.3[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]2.5[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl66"]2.6[/TD]
[TD="align: right"]28[/TD]
[TD="class: xl66"]2.8[/TD]
[TD="align: right"]10[/TD]
[TD="class: xl66"]3[/TD]
[TD="align: right"]24[/TD]
[TD="class: xl66"]3.3[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl66"]3.4[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]4[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]--[/TD]
[TD="align: right"]0[/TD]
[TD="class: xl65"]Campaign 6[/TD]
[TD="align: right"]9468[/TD]
[TD="class: xl66"]2.3[/TD]
[TD="align: right"]105[/TD]
[TD="class: xl66"]2.4[/TD]
[TD="align: right"]749[/TD]
[TD="class: xl66"]2.5[/TD]
[TD="align: right"]246[/TD]
[TD="class: xl66"]2.6[/TD]
[TD="align: right"]133[/TD]
[TD="class: xl66"]2.7[/TD]
[TD="align: right"]1446[/TD]
[TD="class: xl66"]2.8[/TD]
[TD="align: right"]99[/TD]
[TD="class: xl66"]3.1[/TD]
[TD="align: right"]2821[/TD]
[TD="class: xl66"]3.2[/TD]
[TD="align: right"]1883[/TD]
[TD="class: xl66"]3.5[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl66"]3.7[/TD]
[TD="align: right"]707[/TD]
[TD="class: xl66"]3.8[/TD]
[TD="align: right"]653[/TD]
[TD="class: xl66"]4[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl66"]4.2[/TD]
[TD="align: right"]439[/TD]
[TD="class: xl66"]4.3[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl66"]4.9[/TD]
[TD="align: right"]7[/TD]
[TD="class: xl66"]5[/TD]
[TD="align: right"]1[/TD]
[TD="class: xl66"]5.1[/TD]
[TD="align: right"]11[/TD]
[TD="class: xl66"]5.2[/TD]
[TD="align: right"]71[/TD]
[TD="class: xl65"]Campaign 7[/TD]
[TD="align: right"]2419[/TD]
[TD="class: xl66"]1[/TD]
[TD="align: right"]72[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]17[/TD]
[TD="class: xl66"]1.8[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]3[/TD]
[TD="align: right"]398[/TD]
[TD="class: xl66"]3.3[/TD]
[TD="align: right"]435[/TD]
[TD="class: xl66"]3.5[/TD]
[TD="align: right"]332[/TD]
[TD="class: xl66"]3.6[/TD]
[TD="align: right"]288[/TD]
[TD="class: xl66"]3.7[/TD]
[TD="align: right"]843[/TD]
[TD="class: xl66"]4[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]4.3[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl66"]4.5[/TD]
[TD="align: right"]2[/TD]
[TD="class: xl66"]5[/TD]
[TD="align: right"]1[/TD]
[TD="class: xl66"]5.2[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]5.3[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl66"]6[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl66"]6.3[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl65"]Campaign 8[/TD]
[TD="align: right"]7522[/TD]
[TD="class: xl66"]1.1[/TD]
[TD="align: right"]1156[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]876[/TD]
[TD="class: xl66"]1.4[/TD]
[TD="align: right"]868[/TD]
[TD="class: xl66"]1.5[/TD]
[TD="align: right"]440[/TD]
[TD="class: xl66"]1.6[/TD]
[TD="align: right"]399[/TD]
[TD="class: xl66"]1.7[/TD]
[TD="align: right"]266[/TD]
[TD="class: xl66"]1.8[/TD]
[TD="align: right"]345[/TD]
[TD="class: xl66"]1.9[/TD]
[TD="align: right"]125[/TD]
[TD="class: xl66"]2[/TD]
[TD="align: right"]314[/TD]
[TD="class: xl66"]2.1[/TD]
[TD="align: right"]655[/TD]
[TD="class: xl66"]2.2[/TD]
[TD="align: right"]221[/TD]
[TD="class: xl66"]2.3[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl66"]2.4[/TD]
[TD="align: right"]16[/TD]
[TD="class: xl66"]2.5[/TD]
[TD="align: right"]532[/TD]
[TD="class: xl66"]2.6[/TD]
[TD="align: right"]255[/TD]
[TD="class: xl66"]2.7[/TD]
[TD="align: right"]367[/TD]
[TD="class: xl66"]2.8[/TD]
[TD="align: right"]12[/TD]
[TD="class: xl66"]2.9[/TD]
[TD="align: right"]253[/TD]
[TD="class: xl66"]3[/TD]
[TD="align: right"]13[/TD]
[TD="class: xl66"]3.1[/TD]
[TD="align: right"]233[/TD]
[TD="class: xl66"]3.5[/TD]
[TD="align: right"]13[/TD]
[TD="class: xl66"]3.9[/TD]
[TD="align: right"]16[/TD]
[TD="class: xl66"]4.2[/TD]
[TD="align: right"]16[/TD]
[TD="class: xl66"]4.7[/TD]
[TD="align: right"]7[/TD]
[TD="class: xl66"]4.8[/TD]
[TD="align: right"]28[/TD]
[TD="class: xl66"]5[/TD]
[TD="align: right"]10[/TD]
[TD="class: xl65"]Grand Total[/TD]
[TD="align: right"]67343[/TD]
</tbody>
In my pivot table when I click on any of the numbers on the left and click 'group' it comes up with an error message saying "cannot group selection".
Does anyone know why this is happening and how to fix?
Thanks!
I've created a pivot table and am trying to group the rows on the far left column such that the numbers between 1-1,9 are grouped together, 2-2.9 are grouped together, 3-3.9 are grouped together etc. (Ideally I would like to do this first for each campaign and then do the same combining all campaigns.)
<colgroup><col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> </colgroup><tbody>
[TD="class: xl65, width: 92"]Campaign 1[/TD]
[TD="width: 82, align: right"]30356[/TD]
[TD="class: xl67"]1.00[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl67"]1.10[/TD]
[TD="align: right"]2265[/TD]
[TD="class: xl67"]1.30[/TD]
[TD="align: right"]114[/TD]
[TD="class: xl67"]1.40[/TD]
[TD="align: right"]1264[/TD]
[TD="class: xl67"]1.50[/TD]
[TD="align: right"]3898[/TD]
[TD="class: xl67"]1.60[/TD]
[TD="align: right"]3672[/TD]
[TD="class: xl67"]1.70[/TD]
[TD="align: right"]1246[/TD]
[TD="class: xl67"]1.80[/TD]
[TD="align: right"]2160[/TD]
[TD="class: xl67"]1.90[/TD]
[TD="align: right"]1453[/TD]
[TD="class: xl67"]2.00[/TD]
[TD="align: right"]1356[/TD]
[TD="class: xl67"]2.20[/TD]
[TD="align: right"]1312[/TD]
[TD="class: xl67"]2.30[/TD]
[TD="align: right"]362[/TD]
[TD="class: xl67"]2.40[/TD]
[TD="align: right"]1337[/TD]
[TD="class: xl67"]2.50[/TD]
[TD="align: right"]162[/TD]
[TD="class: xl67"]2.60[/TD]
[TD="align: right"]356[/TD]
[TD="class: xl67"]2.70[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl67"]2.80[/TD]
[TD="align: right"]119[/TD]
[TD="class: xl67"]2.90[/TD]
[TD="align: right"]144[/TD]
[TD="class: xl67"]3.00[/TD]
[TD="align: right"]153[/TD]
[TD="class: xl67"]3.10[/TD]
[TD="align: right"]167[/TD]
[TD="class: xl67"]3.30[/TD]
[TD="align: right"]69[/TD]
[TD="class: xl67"]3.40[/TD]
[TD="align: right"]53[/TD]
[TD="class: xl67"]3.50[/TD]
[TD="align: right"]1950[/TD]
[TD="class: xl67"]3.60[/TD]
[TD="align: right"]193[/TD]
[TD="class: xl67"]3.70[/TD]
[TD="align: right"]197[/TD]
[TD="class: xl67"]4.00[/TD]
[TD="align: right"]2102[/TD]
[TD="class: xl67"]4.10[/TD]
[TD="align: right"]1042[/TD]
[TD="class: xl67"]4.20[/TD]
[TD="align: right"]1804[/TD]
[TD="class: xl67"]4.50[/TD]
[TD="align: right"]1307[/TD]
[TD="class: xl65"]Campaign 2[/TD]
[TD="align: right"]7663[/TD]
[TD="class: xl66"]1.1[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]37[/TD]
[TD="class: xl66"]1.9[/TD]
[TD="align: right"]430[/TD]
[TD="class: xl66"]2[/TD]
[TD="align: right"]177[/TD]
[TD="class: xl66"]2.2[/TD]
[TD="align: right"]435[/TD]
[TD="class: xl66"]2.3[/TD]
[TD="align: right"]382[/TD]
[TD="class: xl66"]2.4[/TD]
[TD="align: right"]367[/TD]
[TD="class: xl66"]2.5[/TD]
[TD="align: right"]263[/TD]
[TD="class: xl66"]2.9[/TD]
[TD="align: right"]1586[/TD]
[TD="class: xl66"]3[/TD]
[TD="align: right"]1148[/TD]
[TD="class: xl66"]3.1[/TD]
[TD="align: right"]13[/TD]
[TD="class: xl66"]3.2[/TD]
[TD="align: right"]35[/TD]
[TD="class: xl66"]3.3[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl66"]3.8[/TD]
[TD="align: right"]142[/TD]
[TD="class: xl66"]3.9[/TD]
[TD="align: right"]396[/TD]
[TD="class: xl66"]4[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]4.1[/TD]
[TD="align: right"]706[/TD]
[TD="class: xl66"]4.2[/TD]
[TD="align: right"]283[/TD]
[TD="class: xl66"]4.3[/TD]
[TD="align: right"]269[/TD]
[TD="class: xl66"]4.4[/TD]
[TD="align: right"]346[/TD]
[TD="class: xl66"]4.6[/TD]
[TD="align: right"]269[/TD]
[TD="class: xl66"]5[/TD]
[TD="align: right"]279[/TD]
[TD="class: xl66"]5.1[/TD]
[TD="align: right"]16[/TD]
[TD="class: xl66"]5.7[/TD]
[TD="align: right"]7[/TD]
[TD="class: xl66"]5.9[/TD]
[TD="align: right"]14[/TD]
[TD="class: xl66"]6.1[/TD]
[TD="align: right"]40[/TD]
[TD="class: xl66"]6.2[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl65"]Campaign 3[/TD]
[TD="align: right"]1042[/TD]
[TD="class: xl66"]1[/TD]
[TD="align: right"]465[/TD]
[TD="class: xl66"]1.1[/TD]
[TD="align: right"]232[/TD]
[TD="class: xl66"]1.2[/TD]
[TD="align: right"]105[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]240[/TD]
[TD="class: xl65"]Campaign 4[/TD]
[TD="align: right"]6311[/TD]
[TD="class: xl66"]1[/TD]
[TD="align: right"]2458[/TD]
[TD="class: xl66"]1.1[/TD]
[TD="align: right"]78[/TD]
[TD="class: xl66"]1.2[/TD]
[TD="align: right"]120[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]313[/TD]
[TD="class: xl66"]1.4[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]1.9[/TD]
[TD="align: right"]274[/TD]
[TD="class: xl66"]2[/TD]
[TD="align: right"]26[/TD]
[TD="class: xl66"]2.1[/TD]
[TD="align: right"]278[/TD]
[TD="class: xl66"]2.2[/TD]
[TD="align: right"]540[/TD]
[TD="class: xl66"]2.3[/TD]
[TD="align: right"]46[/TD]
[TD="class: xl66"]2.4[/TD]
[TD="align: right"]515[/TD]
[TD="class: xl66"]2.5[/TD]
[TD="align: right"]17[/TD]
[TD="class: xl66"]2.7[/TD]
[TD="align: right"]396[/TD]
[TD="class: xl66"]3.4[/TD]
[TD="align: right"]137[/TD]
[TD="class: xl66"]3.6[/TD]
[TD="align: right"]259[/TD]
[TD="class: xl66"]3.7[/TD]
[TD="align: right"]183[/TD]
[TD="class: xl66"]3.8[/TD]
[TD="align: right"]211[/TD]
[TD="class: xl66"]3.9[/TD]
[TD="align: right"]104[/TD]
[TD="class: xl66"]4.2[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]4.4[/TD]
[TD="align: right"]193[/TD]
[TD="class: xl66"]4.9[/TD]
[TD="align: right"]15[/TD]
[TD="class: xl66"]5[/TD]
[TD="align: right"]118[/TD]
[TD="class: xl66"]5.2[/TD]
[TD="align: right"]12[/TD]
[TD="class: xl66"]5.7[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl66"]5.8[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]--[/TD]
[TD="align: right"]0[/TD]
[TD="class: xl65"]Campaign 5[/TD]
[TD="align: right"]2562[/TD]
[TD="class: xl66"]1[/TD]
[TD="align: right"]800[/TD]
[TD="class: xl66"]1.2[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]1.6[/TD]
[TD="align: right"]220[/TD]
[TD="class: xl66"]1.7[/TD]
[TD="align: right"]12[/TD]
[TD="class: xl66"]1.8[/TD]
[TD="align: right"]101[/TD]
[TD="class: xl66"]1.9[/TD]
[TD="align: right"]351[/TD]
[TD="class: xl66"]2[/TD]
[TD="align: right"]481[/TD]
[TD="class: xl66"]2.1[/TD]
[TD="align: right"]477[/TD]
[TD="class: xl66"]2.2[/TD]
[TD="align: right"]18[/TD]
[TD="class: xl66"]2.3[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]2.5[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl66"]2.6[/TD]
[TD="align: right"]28[/TD]
[TD="class: xl66"]2.8[/TD]
[TD="align: right"]10[/TD]
[TD="class: xl66"]3[/TD]
[TD="align: right"]24[/TD]
[TD="class: xl66"]3.3[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl66"]3.4[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]4[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]--[/TD]
[TD="align: right"]0[/TD]
[TD="class: xl65"]Campaign 6[/TD]
[TD="align: right"]9468[/TD]
[TD="class: xl66"]2.3[/TD]
[TD="align: right"]105[/TD]
[TD="class: xl66"]2.4[/TD]
[TD="align: right"]749[/TD]
[TD="class: xl66"]2.5[/TD]
[TD="align: right"]246[/TD]
[TD="class: xl66"]2.6[/TD]
[TD="align: right"]133[/TD]
[TD="class: xl66"]2.7[/TD]
[TD="align: right"]1446[/TD]
[TD="class: xl66"]2.8[/TD]
[TD="align: right"]99[/TD]
[TD="class: xl66"]3.1[/TD]
[TD="align: right"]2821[/TD]
[TD="class: xl66"]3.2[/TD]
[TD="align: right"]1883[/TD]
[TD="class: xl66"]3.5[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl66"]3.7[/TD]
[TD="align: right"]707[/TD]
[TD="class: xl66"]3.8[/TD]
[TD="align: right"]653[/TD]
[TD="class: xl66"]4[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl66"]4.2[/TD]
[TD="align: right"]439[/TD]
[TD="class: xl66"]4.3[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl66"]4.9[/TD]
[TD="align: right"]7[/TD]
[TD="class: xl66"]5[/TD]
[TD="align: right"]1[/TD]
[TD="class: xl66"]5.1[/TD]
[TD="align: right"]11[/TD]
[TD="class: xl66"]5.2[/TD]
[TD="align: right"]71[/TD]
[TD="class: xl65"]Campaign 7[/TD]
[TD="align: right"]2419[/TD]
[TD="class: xl66"]1[/TD]
[TD="align: right"]72[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]17[/TD]
[TD="class: xl66"]1.8[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]3[/TD]
[TD="align: right"]398[/TD]
[TD="class: xl66"]3.3[/TD]
[TD="align: right"]435[/TD]
[TD="class: xl66"]3.5[/TD]
[TD="align: right"]332[/TD]
[TD="class: xl66"]3.6[/TD]
[TD="align: right"]288[/TD]
[TD="class: xl66"]3.7[/TD]
[TD="align: right"]843[/TD]
[TD="class: xl66"]4[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl66"]4.3[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl66"]4.5[/TD]
[TD="align: right"]2[/TD]
[TD="class: xl66"]5[/TD]
[TD="align: right"]1[/TD]
[TD="class: xl66"]5.2[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl66"]5.3[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl66"]6[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl66"]6.3[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl65"]Campaign 8[/TD]
[TD="align: right"]7522[/TD]
[TD="class: xl66"]1.1[/TD]
[TD="align: right"]1156[/TD]
[TD="class: xl66"]1.3[/TD]
[TD="align: right"]876[/TD]
[TD="class: xl66"]1.4[/TD]
[TD="align: right"]868[/TD]
[TD="class: xl66"]1.5[/TD]
[TD="align: right"]440[/TD]
[TD="class: xl66"]1.6[/TD]
[TD="align: right"]399[/TD]
[TD="class: xl66"]1.7[/TD]
[TD="align: right"]266[/TD]
[TD="class: xl66"]1.8[/TD]
[TD="align: right"]345[/TD]
[TD="class: xl66"]1.9[/TD]
[TD="align: right"]125[/TD]
[TD="class: xl66"]2[/TD]
[TD="align: right"]314[/TD]
[TD="class: xl66"]2.1[/TD]
[TD="align: right"]655[/TD]
[TD="class: xl66"]2.2[/TD]
[TD="align: right"]221[/TD]
[TD="class: xl66"]2.3[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl66"]2.4[/TD]
[TD="align: right"]16[/TD]
[TD="class: xl66"]2.5[/TD]
[TD="align: right"]532[/TD]
[TD="class: xl66"]2.6[/TD]
[TD="align: right"]255[/TD]
[TD="class: xl66"]2.7[/TD]
[TD="align: right"]367[/TD]
[TD="class: xl66"]2.8[/TD]
[TD="align: right"]12[/TD]
[TD="class: xl66"]2.9[/TD]
[TD="align: right"]253[/TD]
[TD="class: xl66"]3[/TD]
[TD="align: right"]13[/TD]
[TD="class: xl66"]3.1[/TD]
[TD="align: right"]233[/TD]
[TD="class: xl66"]3.5[/TD]
[TD="align: right"]13[/TD]
[TD="class: xl66"]3.9[/TD]
[TD="align: right"]16[/TD]
[TD="class: xl66"]4.2[/TD]
[TD="align: right"]16[/TD]
[TD="class: xl66"]4.7[/TD]
[TD="align: right"]7[/TD]
[TD="class: xl66"]4.8[/TD]
[TD="align: right"]28[/TD]
[TD="class: xl66"]5[/TD]
[TD="align: right"]10[/TD]
[TD="class: xl65"]Grand Total[/TD]
[TD="align: right"]67343[/TD]
</tbody>
In my pivot table when I click on any of the numbers on the left and click 'group' it comes up with an error message saying "cannot group selection".
Does anyone know why this is happening and how to fix?
Thanks!