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>
</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.)
Campaign 1 | 30356 |
1.00 | 6 |
1.10 | 2265 |
1.30 | 114 |
1.40 | 1264 |
1.50 | 3898 |
1.60 | 3672 |
1.70 | 1246 |
1.80 | 2160 |
1.90 | 1453 |
2.00 | 1356 |
2.20 | 1312 |
2.30 | 362 |
2.40 | 1337 |
2.50 | 162 |
2.60 | 356 |
2.70 | 93 |
2.80 | 119 |
2.90 | 144 |
3.00 | 153 |
3.10 | 167 |
3.30 | 69 |
3.40 | 53 |
3.50 | 1950 |
3.60 | 193 |
3.70 | 197 |
4.00 | 2102 |
4.10 | 1042 |
4.20 | 1804 |
4.50 | 1307 |
Campaign 2 | 7663 |
1.1 | 8 |
1.3 | 37 |
1.9 | 430 |
2 | 177 |
2.2 | 435 |
2.3 | 382 |
2.4 | 367 |
2.5 | 263 |
2.9 | 1586 |
3 | 1148 |
3.1 | 13 |
3.2 | 35 |
3.3 | 3 |
3.8 | 142 |
3.9 | 396 |
4 | 6 |
4.1 | 706 |
4.2 | 283 |
4.3 | 269 |
4.4 | 346 |
4.6 | 269 |
5 | 279 |
5.1 | 16 |
5.7 | 7 |
5.9 | 14 |
6.1 | 40 |
6.2 | 6 |
Campaign 3 | 1042 |
1 | 465 |
1.1 | 232 |
1.2 | 105 |
1.3 | 240 |
Campaign 4 | 6311 |
1 | 2458 |
1.1 | 78 |
1.2 | 120 |
1.3 | 313 |
1.4 | 5 |
1.9 | 274 |
2 | 26 |
2.1 | 278 |
2.2 | 540 |
2.3 | 46 |
2.4 | 515 |
2.5 | 17 |
2.7 | 396 |
3.4 | 137 |
3.6 | 259 |
3.7 | 183 |
3.8 | 211 |
3.9 | 104 |
4.2 | 5 |
4.4 | 193 |
4.9 | 15 |
5 | 118 |
5.2 | 12 |
5.7 | 3 |
5.8 | 5 |
-- | 0 |
Campaign 5 | 2562 |
1 | 800 |
1.2 | 5 |
1.3 | 6 |
1.6 | 220 |
1.7 | 12 |
1.8 | 101 |
1.9 | 351 |
2 | 481 |
2.1 | 477 |
2.2 | 18 |
2.3 | 6 |
2.5 | 8 |
2.6 | 28 |
2.8 | 10 |
3 | 24 |
3.3 | 4 |
3.4 | 5 |
4 | 6 |
-- | 0 |
Campaign 6 | 9468 |
2.3 | 105 |
2.4 | 749 |
2.5 | 246 |
2.6 | 133 |
2.7 | 1446 |
2.8 | 99 |
3.1 | 2821 |
3.2 | 1883 |
3.5 | 4 |
3.7 | 707 |
3.8 | 653 |
4 | 3 |
4.2 | 439 |
4.3 | 90 |
4.9 | 7 |
5 | 1 |
5.1 | 11 |
5.2 | 71 |
Campaign 7 | 2419 |
1 | 72 |
1.3 | 17 |
1.8 | 6 |
3 | 398 |
3.3 | 435 |
3.5 | 332 |
3.6 | 288 |
3.7 | 843 |
4 | 5 |
4.3 | 3 |
4.5 | 2 |
5 | 1 |
5.2 | 6 |
5.3 | 4 |
6 | 3 |
6.3 | 4 |
Campaign 8 | 7522 |
1.1 | 1156 |
1.3 | 876 |
1.4 | 868 |
1.5 | 440 |
1.6 | 399 |
1.7 | 266 |
1.8 | 345 |
1.9 | 125 |
2 | 314 |
2.1 | 655 |
2.2 | 221 |
2.3 | 86 |
2.4 | 16 |
2.5 | 532 |
2.6 | 255 |
2.7 | 367 |
2.8 | 12 |
2.9 | 253 |
3 | 13 |
3.1 | 233 |
3.5 | 13 |
3.9 | 16 |
4.2 | 16 |
4.7 | 7 |
4.8 | 28 |
5 | 10 |
Grand Total | 67343 |
<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>
</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!