Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following expression in a straight table. If I use Expression total or sum of the rows I get the wrong subtotals in the gross sales collumn. the dimension description is a category of product we sell.
Sum(Gross_Sales*Multiplier)*COUNT(DISTINCT TBI_UNIQUE)/SUM(Multiplier)
DESCRIPTION | Net Sales | Gross Sales | Kgs | Cases | Total Cost | Tea Cost | Pack Cost | Lab/OH Cost | Actual Cost | New Kgs | Old Kgs |
---|---|---|---|---|---|---|---|---|---|---|---|
539621 | 533607 | 345521 | 181361 | 392796 | 132862 | 167182 | 45085 | 389365 | 26749 | 27089.52 | |
Decaf | 4180 | 4180 | 191 | 1908 | 3726 | 1285 | 1424 | 0 | 3270 | 191 | 190.80 |
Earl Grey Base | 1713 | 1713 | 185 | 693 | 1262 | 880 | 224 | 158 | 1312 | 185 | 184.80 |
Rare Teas | 16432 | 16432 | 0 | 472 | 12568 | 12311 | 89 | 168 | 12440 | 208 | 208.00 |
Earl Grey | 29706 | 29706 | 2144 | 8867 | 20549 | 8506 | 8269 | 3534 | 22029 | 2144 | 2144.00 |
Fruit & Herb | 75428 | 75428 | 1604 | 21664 | 53068 | 11256 | 31568 | 9748 | 56441 | 1604 | 1603.59 |
Tea Flavoured | 101073 | 101073 | 19150 | 31188 | 71493 | 19735 | 32035 | 10468 | 72197 | 5147 | 5147.49 |
Speciality | 311088 | 305074 | 322248 | 116569 | 230129 | 78888 | 93573 | 21008 | 221677 | 17270 | 17610.83 |
If I change the dimensions to include the actual product line as well I get the correct total in gross sales but I want to show just the summarised data. Can anyone help me?
DESCRIPTION | TBI_PART_ONLY | Net Sales | Gross Sales | Kgs | Cases | Total Cost | Tea Cost | Pack Cost | Lab/OH Cost | Actual Cost | New Kgs | Old Kgs |
---|---|---|---|---|---|---|---|---|---|---|---|---|
539621 | 531789 | 345521 | 181361 | 392796 | 132862 | 167182 | 45085 | 389365 | 26878 | 27089.52 | ||
Speciality | 410-41-743 | 188 | 94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 |
Rare Teas | 410-40-734 | 42 | 42 | 0 | 2 | 35 | 340 | 1 | 37 | 1 | 1.00 | |
Rare Teas | 410-40-781 | 20 | 20 | 0 | 2 | 15 | 14 | 0 | 1 | 15 | 1 | 1.00 |
Rare Teas | 410-40-782 | 30 | 30 | 0 | 2 | 18 | 16 | 0 | 2 | 18 | 1 | 1.00 |
Rare Teas | 410-40-7058 | 323 | 323 | 0 | 2 | 224 | 222 | 0 | 2 | 170 | 1 | 1.00 |
Rare Teas | 410-40-796 | 310 | 310 | 0 | 3 | 149 | 147 | 0 | 1 | 149 | 2 | 1.50 |
Rare Teas | 410-40-707 | 93 | 93 | 0 | 4 | 172 | 170 | 0 | 2 | 178 | 2 | 2.00 |
Rare Teas | 410-40-742 | 89 | 89 | 0 | 4 | 81 | 80 | 0 | 1 | 55 | 2 | 2.00 |
Rare Teas | 410-40-743 | 89 | 89 | 0 | 4 | 81 | 80 | 0 | 1 | 77 | 2 | 2.00 |
Rare Teas | 410-40-7004 | 856 | 856 | 0 | 4 | 701 | 700 | 0 | 1 | 701 | 2 | 2.00 |
Rare Teas | 410-40-705 | 458 | 458 | 0 | 6 | 449 | 449 | 0 | 0 | 316 | 3 | 3.00 |
Rare Teas | 410-40-713 | 398 | 398 | 0 | 6 | 281 | 280 | 0 | 1 | 241 | 3 | 3.00 |
Rare Teas | 410-40-721 | 169 | 169 | 0 | 6 | 140 | 137 | 0 | 3 | 140 | 3 | 3.00 |
Rare Teas | 410-40-738 | 133 | 133 | 0 | 6 | 159 | 157 | 0 | 3 | 132 | 3 | 3.00 |
Rare Teas | 410-40-756 | 273 | 273 | 0 | 6 | 288 | 286 | 0 | 3 | 267 | 3 | 3.00 |
Rare Teas | 410-40-7038 | 133 | 133 | 0 | 6 | 189 | 186 | 0 | 3 | 123 | 3 | 3.00 |
Rare Teas | 410-40-7039 | 242 | 242 | 0 | 6 | 227 | 224 | 0 | 3 | 227 | 3 | 3.00 |
Rare Teas | 410-40-7045 | 21 | 21 | 0 | 6 | 21 | 17 | 0 | 4 | 21 | 3 | 3.00 |
Rare Teas | 410-40-7060 | 141 | 141 | 0 | 6 | 102 | 102 | 0 | 0 | 102 | 3 | 3.00 |
Rare Teas | 410-40-7064 | 574 | 574 | 0 | 6 | 389 | 384 | 0 | 6 | 284 | 3 | 3.00 |
Rare Teas | 410-40-7068 | 238 | 238 | 0 | 6 | 167 | 167 | 0 | 0 | 167 | 3 | 3.00 |
Rare Teas | 410-40-786 | 295 | 295 | 0 | 8 | 317 | 315 | 0 | 2 | 346 | 4 | 4.00 |
Rare Teas | 410-40-740 | 223 | 223 | 0 | 10 | 202 | 200 | 0 | 2 | 192 | 5 | 5.00 |
Rare Teas | 410-40-741 | 223 | 223 | 0 | 10 | 191 | 189 | 0 | 2 | 202 | 5 | 5.00 |
Rare Teas | 410-40-7002 | 896 | 896 | 0 | 10 | 699 | 697 | 0 | 2 | 726 | 5 | 5.00 |
Rare Teas | 410-40-708 | 278 | 278 | 0 | 12 | 268 | 268 | 0 | 0 | 269 | 6 | 6.00 |
Rare Teas | 410-40-735 | 431 | 431 | 0 | 12 | 342 | 336 | 0 | 6 | 379 | 6 | 6.00 |
Rare Teas | 410-40-7042 | 314 | 314 | 0 | 12 | 308 | 305 | 0 | 3 | 210 | 6 | 6.00 |
Rare Teas | 410-40-7069 | 443 | 443 | 0 | 12 | 309 | 309 | 0 | 0 | 309 | 6 | 6.00 |
Rare Teas | 410-40-746 | 492 | 492 | 0 | 18 | 350 | 342 | 0 | 8 | 403 | 9 | 9.00 |
Rare Teas | 410-40-755 | 88 | 88 | 0 | 18 | 127 | 119 | 0 | 8 | 127 | 9 | 9.00 |
Rare Teas | 410-40-787 | 366 | 366 | 0 | 18 | 218 | 214 | 0 | 4 | 274 | 9 | 9.00 |
Rare Teas | 410-40-7046 | 733 | 733 | 0 | 18 | 550 | 538 | 0 | 12 | 550 | 9 | 9.00 |
Rare Teas | 410-40-749 | 1398 | 1398 | 0 | 24 | 566 | 555 | 0 | 10 | 600 | 12 | 12.00 |
Rare Teas | 410-40-7072 | 1563 | 1563 | 0 | 24 | 1158 | 1140 | 0 | 18 | 1158 | 12 | 12.00 |
Rare Teas | 410-40-7070 | 167 | 167 | 0 | 30 | 113 | 101 | 0 | 11 | 113 | 15 | 15.00 |
Rare Teas | 410-40-7071 | 1593 | 1593 | 0 | 30 | 1177 | 1155 | 0 | 22 | 1177 | 15 | 15.00 |
Rare Teas | 410-40-704 | 1990 | 1990 | 0 | 48 | 1532 | 1522 | 0 | 10 | 1726 | 24 | 24.00 |
Speciality | 410-40-456 | 26 | 26 | 3 | 8 | 16 | 11 | 1 | 3 | 13 | 3 | 3.00 |
Tea Flavoured | 410-40-415 | 54 | 54 | 6 | 16 | 32 | 23 | 2 | 7 | 34 | 6 | 6.00 |
Speciality | 410-40-407 | 49 | 49 | 6 | 16 | 31 | 23 | 2 | 6 | 31 | 6 | 6.00 |
Speciality | 410-40-463 | 44 | 44 | 6 | 16 | 37 | 29 | 2 | 7 | 37 | 6 | 6.00 |
Fruit & Herb | 410-40-412 | 84 | 84 | 9 | 24 | 34 | 21 | 3 | 10 | 40 | 9 | 9.00 |
Tea Flavoured | 410-40-411 | 84 | 84 | 9 | 24 | 39 | 26 | 3 | 10 | 43 | 9 | 9.00 |
Tea Flavoured | 410-40-417 | 82 | 82 | 9 | 24 | 47 | 33 | 3 | 10 | 53 | 9 | 9.00 |
Speciality | 410-41-193 | 73 | 73 | 6 | 24 | 37 | 28 | 3 | 6 | 37 | 6 | 6.00 |
Speciality | 410-40-408 | 152 | 152 | 9 | 27 | 85 | 72 | 3 | 10 | 85 | 9 | 9.00 |
Speciality | 410-40-406 | 149 | 149 | 12 | 32 | 69 | 52 | 4 | 13 | 68 | 12 | 12.00 |
Tea Flavoured | 410-40-420 | 109 | 109 | 12 | 32 | 71 | 53 | 4 | 14 | 79 | 12 | 12.00 |
Speciality | 410-45-016 | 30 | 30 | 10 | 12 | 49 | 35 | 4 | 9 | 48 | 10 | 9.60 |
Speciality | 410-40-436 | 220 | 220 | 18 | 48 | 95 | 69 | 6 | 20 | 99 | 18 | 18.00 |
Speciality | 410-40-448 | 137 | 137 | 14 | 56 | 66 | 44 | 7 | 15 | 73 | 14 | 14.00 |
Speciality | 410-40-452 | 192 | 192 | 21 | 56 | 129 | 102 | 7 | 20 | 129 | 21 | 21.00 |
Speciality | 410-40-434 | 232 | 232 | 21 | 49 | 316 | 286 | 7 | 23 | 315 | 21 | 21.00 |
Tea Flavoured | 410-40-409 | 182 | 182 | 21 | 56 | 81 | 50 | 7 | 24 | 86 | 21 | 21.00 |
Speciality | 410-40-419 | 190 | 190 | 21 | 56 | 128 | 96 | 7 | 24 | 157 | 21 | 21.00 |
Tea Flavoured | 410-40-414 | 217 | 217 | 24 | 64 | 147 | 111 | 8 | 28 | 167 | 24 | 24.00 |
Speciality | 410-40-433 | 454 | 454 | 27 | 72 | 136 | 98 | 9 | 30 | 136 | 27 | 27.00 |
Speciality | 410-40-454 | 277 | 277 | 27 | 72 | 184 | 150 | 9 | 26 | 166 | 27 | 27.00 |
Tea Flavoured | 410-40-443 | 289 | 289 | 27 | 72 | 133 | 98 | 9 | 27 | 155 | 27 | 27.00 |
Fruit & Herb | 410-41-562 | 30 | 30 | 1 | 16 | 21 | 5 | 9 | 7 | 24 | 1 | 0.72 |
Speciality | 410-45-105 | 247 | 247 | 15 | 90 | 108 | 84 | 10 | 14 | 108 | 15 | 15.00 |
Tea Flavoured | 410-40-442 | 289 | 289 | 33 | 88 | 192 | 145 | 11 | 36 | 180 | 33 | 33.00 |
Earl Grey | 410-40-437 | 1396 | 1396 | 162 | 432 | 796 | 630 | 12 | 154 | 954 | 162 | 162.00 |
Tea Flavoured | 410-40-413 | 373 | 373 | 39 | 104 | 145 | 89 | 13 | 43 | 162 | 39 | 39.00 |
Speciality | 410-40-429 | 331 | 331 | 45 | 120 | 271 | 213 | 15 | 43 | 276 | 45 | 45.00 |
Speciality | 410-40-410 | 495 | 495 | 48 | 128 | 252 | 186 | 16 | 51 | 252 | 48 | 48.00 |
Speciality | 410-40-424 | 535 | 535 | 51 | 136 | 334 | 268 | 17 | 49 | 361 | 51 | 51.00 |
Speciality | 410-40-428 | 401 | 401 | 51 | 136 | 304 | 238 | 17 | 49 | 318 | 51 | 51.00 |
Speciality | 410-40-425 | 522 | 522 | 54 | 144 | 327 | 257 | 18 | 52 | 323 | 54 | 54.00 |
Speciality | 410-40-431 | 1302 | 1302 | 54 | 144 | 633 | 564 | 18 | 52 | 648 | 54 | 54.00 |
Speciality | 410-41-873/1 | 109 | 109 | 7 | 6 | 74 | 21 | 18 | 0 | 86 | 7 | 7.20 |
Speciality | 410-40-430 | 430 | 430 | 57 | 152 | 307 | 233 | 19 | 55 | 301 | 57 | 57.00 |
Speciality | 410-40-440 | 1468 | 1468 | 57 | 152 | 1426 | 1347 | 19 | 60 | 1423 | 57 | 57.00 |
Earl Grey | 410-45-103 | 257 | 257 | 18 | 150 | 115 | 75 | 22 | 19 | 131 | 18 | 18.00 |
Speciality | 410-41-304 | 41 | 41 | 1144 | 12 | 35 | 4 | 23 | 1 | 34 | 1 | 1.20 |
Speciality | 410-40-423 | 558 | 558 | 75 | 200 | 367 | 270 | 24 | 72 | 356 | 75 | 75.00 |
Speciality | 410-40-427 | 532 | 532 | 81 | 216 | 340 | 235 | 26 | 78 | 340 | 81 | 81.00 |
Tea Flavoured | 410-40-441 | 995 | 995 | 90 | 240 | 530 | 414 | 29 | 87 | 501 | 90 | 90.00 |
Speciality | 410-41-525/1 | 90 | 90 | 5 | 48 | 76 | 21 | 29 | 0 | 67 | 5 | 4.80 |
Earl Grey | 410-40-438 | 744 | 744 | 89 | 237 | 489 | 374 | 30 | 85 | 560 | 89 | 89.00 |
Speciality | 410-40-439 | 602 | 602 | 62 | 248 | 452 | 356 | 30 | 66 | 450 | 62 | 62.00 |
Fruit & Herb | 410-41-564 | 83 | 83 | 2 | 48 | 71 | 14 | 30 | 27 | 67 | 2 | 2.16 |
Speciality | 410-41-527/1 | 112 | 112 | 6 | 60 | 91 | 27 | 32 | 0 | 85 | 6 | 6.00 |
Speciality | 410-40-422 | 758 | 758 | 102 | 272 | 519 | 388 | 33 | 98 | 504 | 102 | 102.00 |
Speciality | 410-41-309 | 266 | 266 | 15 | 55 | 118 | 60 | 38 | 20 | 167 | 15 | 15.00 |
Speciality | 410-41-526 | 110 | 110 | 6 | 130 | 73 | 16 | 40 | 17 | 64 | 6 | 6.00 |
Tea Flavoured | 410-40-444 | 1214 | 1214 | 90 | 360 | 723 | 588 | 44 | 92 | 244 | 90 | 90.00 |
Speciality | 410-40-421 | 1048 | 1048 | 141 | 376 | 719 | 537 | 46 | 136 | 741 | 141 | 141.00 |
Speciality | 410-41-874/1 | 212 | 212 | 14 | 12 | 164 | 45 | 48 | 0 | 153 | 14 | 14.40 |
Speciality | 410-41-875/1 | 218 | 218 | 14 | 12 | 161 | 42 | 49 | 0 | 146 | 14 | 14.40 |
Speciality | 410-41-150 | 189 | 189 | 12 | 80 | 121 | 46 | 52 | 24 | 131 | 12 | 12.00 |
Speciality | 410-41-151 | 294 | 294 | 12 | 80 | 175 | 96 | 55 | 24 | 175 | 12 | 12.00 |
Speciality | 410-41-111 | 163 | 163 | 12 | 72 | 142 | 58 | 62 | 22 | 138 | 12 | 12.00 |
Tea Flavoured | 410-41-852/1 | 476 | 476 | 29 | 24 | 380 | 166 | 73 | 0 | 419 | 29 | 28.80 |
Speciality | 410-41-834 | 251 | 251 | 8 | 18 | 155 | 36 | 83 | 36 | 212 | 8 | 7.50 |
Tea Flavoured | 410-41-833 | 252 | 252 | 8 | 18 | 148 | 29 | 83 | 36 | 154 | 8 | 7.50 |
Rare Teas | 410-41-318 | 303 | 303 | 0 | 65 | 255 | 154 | 89 | 12 | 262 | 5 | 4.50 |
Speciality | 410-41-317 | 131 | 131 | 151 | 80 | 120 | 12 | 92 | 16 | 79 | 6 | 6.00 |
Speciality | 410-41-315 | 283 | 283 | 295 | 160 | 176 | 52 | 94 | 30 | 183 | 12 | 12.00 |
Tea Flavoured | 410-41-851/1 | 474 | 474 | 29 | 24 | 307 | 67 | 98 | 0 | 292 | 29 | 28.80 |
Speciality | 410-41-135 | 333 | 333 | 15 | 90 | 187 | 58 | 101 | 27 | 198 | 15 | 15.00 |
Speciality | 410-41-153 | 450 | 450 | 23 | 150 | 246 | 98 | 104 | 44 | 254 | 23 | 22.50 |
Speciality | 410-41-114 | 349 | 349 | 24 | 128 | 230 | 83 | 107 | 40 | 251 | 24 | 24.00 |
Speciality | 410-41-112 | 389 | 389 | 23 | 120 | 274 | 125 | 109 | 41 | 260 | 23 | 22.50 |
Tea Flavoured | 410-41-853/1 | 478 | 478 | 29 | 24 | 356 | 97 | 117 | 0 | 318 | 29 | 28.80 |
Speciality | 410-41-139 | 485 | 485 | 18 | 120 | 227 | 65 | 128 | 34 | 237 | 18 | 18.00 |
Tea Flavoured | 410-41-543/1 | 618 | 618 | 30 | 300 | 362 | 66 | 136 | 0 | 485 | 30 | 30.00 |
Speciality | 410-41-510/1 | 556 | 556 | 30 | 300 | 415 | 94 | 161 | 0 | 387 | 30 | 30.00 |
Tea Flavoured | 410-41-544/1 | 640 | 640 | 30 | 300 | 389 | 66 | 163 | 0 | 515 | 30 | 30.00 |
Decaf | 410-41-513/1 | 709 | 709 | 31 | 312 | 522 | 189 | 167 | 0 | 588 | 31 | 31.20 |
Speciality | 410-41-854/1 | 476 | 476 | 29 | 24 | 415 | 105 | 168 | 0 | 357 | 29 | 28.80 |
Tea Flavoured | 410-41-171 | 623 | 623 | 38 | 250 | 408 | 167 | 169 | 72 | 470 | 38 | 37.50 |
Tea Flavoured | 410-41-172 | 627 | 627 | 38 | 250 | 384 | 140 | 169 | 75 | 436 | 38 | 37.50 |
Speciality | 410-45-107 | 2134 | 2134 | 146 | 1220 | 870 | 543 | 172 | 155 | 875 | 146 | 146.40 |
Speciality | 410-41-316 | 483 | 483 | 531 | 288 | 314 | 73 | 186 | 54 | 333 | 22 | 21.60 |
Tea Flavoured | 410-41-156 | 735 | 735 | 44 | 290 | 406 | 126 | 188 | 92 | 456 | 44 | 43.50 |
Speciality | 410-41-103 | 708 | 708 | 42 | 224 | 480 | 201 | 204 | 76 | 480 | 42 | 42.00 |
Speciality | 410-41-405 | 1502 | 1502 | 180 | 675 | 1064 | 689 | 218 | 157 | 1091 | 180 | 180.00 |
Fruit & Herb | 410-41-522/1 | 692 | 692 | 36 | 360 | 571 | 159 | 220 | 0 | 505 | 36 | 36.00 |
Earl Grey Base | 410-41-406 | 1713 | 1713 | 185 | 693 | 1262 | 880 | 224 | 158 | 1312 | 185 | 184.80 |
Tea Flavoured | 410-41-170 | 870 | 870 | 53 | 350 | 542 | 206 | 235 | 101 | 627 | 53 | 52.50 |
Speciality | 410-41-468 | 533 | 533 | 627 | 100 | 573 | 59 | 241 | 44 | 227 | 15 | 15.00 |
Tea Flavoured | 410-41-830 | 634 | 634 | 23 | 54 | 437 | 88 | 242 | 107 | 456 | 23 | 22.50 |
Tea Flavoured | 410-41-550/1 | 913 | 913 | 44 | 444 | 582 | 104 | 242 | 0 | 563 | 44 | 44.40 |
Speciality | 410-41-474 | 1453 | 1453 | 149 | 144 | 914 | 635 | 253 | 27 | 1234 | 10 | 9.72 |
Speciality | 410-41-523/1 | 870 | 870 | 48 | 480 | 606 | 90 | 261 | 0 | 566 | 48 | 48.00 |
Speciality | 410-41-596 | 692 | 692 | 11 | 250 | 502 | 118 | 274 | 111 | 448 | 11 | 11.25 |
Speciality | 410-41-598 | 653 | 653 | 11 | 250 | 444 | 59 | 274 | 111 | 458 | 11 | 11.25 |
Speciality | 410-41-542/1 | 1050 | 1050 | 51 | 510 | 689 | 140 | 277 | 0 | 625 | 51 | 51.00 |
Tea Flavoured | 410-41-551/1 | 1288 | 1288 | 62 | 624 | 977 | 359 | 286 | 0 | 1060 | 62 | 62.40 |
Tea Flavoured | 410-41-831 | 635 | 635 | 23 | 54 | 495 | 100 | 287 | 107 | 469 | 23 | 22.50 |
Speciality | 410-41-478 | 1132 | 1132 | 165 | 160 | 519 | 200 | 290 | 29 | 806 | 11 | 10.80 |
Tea Flavoured | 410-41-578 | 599 | 599 | 9 | 200 | 508 | 66 | 300 | 142 | 447 | 9 | 9.00 |
Fruit & Herb | 410-41-158 | 1142 | 1142 | 68 | 450 | 610 | 160 | 307 | 143 | 782 | 68 | 67.50 |
Speciality | 410-41-524 | 877 | 877 | 37 | 806 | 550 | 133 | 310 | 106 | 435 | 37 | 37.20 |
Tea Flavoured | 410-41-157 | 1249 | 1249 | 73 | 486 | 637 | 168 | 315 | 154 | 747 | 73 | 72.87 |
Tea Flavoured | 410-41-189 | 612 | 612 | 9 | 250 | 523 | 34 | 317 | 172 | 560 | 9 | 9.00 |
Tea Flavoured | 410-41-832 | 845 | 845 | 30 | 72 | 604 | 139 | 322 | 143 | 719 | 30 | 30.00 |
Tea Flavoured | 410-41-152 | 1210 | 1210 | 75 | 500 | 652 | 179 | 324 | 148 | 746 | 75 | 75.00 |
Tea Flavoured | 410-41-552/1 | 1117 | 1117 | 54 | 540 | 801 | 183 | 330 | 0 | 730 | 54 | 54.00 |
Speciality | 410-41-104 | 943 | 943 | 68 | 450 | 657 | 197 | 339 | 122 | 567 | 68 | 67.50 |
Tea Flavoured | 410-41-174 | 1239 | 1239 | 75 | 500 | 836 | 348 | 339 | 149 | 958 | 75 | 75.00 |
Speciality | 410-41-524/1 | 1093 | 1093 | 45 | 450 | 757 | 169 | 348 | 0 | 605 | 45 | 45.00 |
Fruit & Herb | 410-41-545/1 | 1187 | 1187 | 57 | 570 | 838 | 185 | 349 | 0 | 799 | 57 | 57.00 |
Tea Flavoured | 410-41-855/1 | 1383 | 1383 | 86 | 72 | 1030 | 253 | 351 | 0 | 963 | 86 | 86.40 |
Earl Grey | 410-41-540/1 | 974 | 974 | 45 | 450 | 679 | 84 | 354 | 0 | 560 | 45 | 45.00 |
Tea Flavoured | 410-41-109 | 1336 | 1336 | 74 | 392 | 832 | 339 | 356 | 137 | 825 | 74 | 73.50 |
Speciality | 410-41-407 | 2497 | 2497 | 299 | 1123 | 1767 | 1143 | 362 | 261 | 1661 | 299 | 299.40 |
Earl Grey | 410-41-107 | 1181 | 1181 | 75 | 450 | 802 | 293 | 370 | 139 | 849 | 75 | 75.00 |
Tea Flavoured | 410-41-106 | 1213 | 1213 | 77 | 408 | 858 | 335 | 371 | 152 | 879 | 77 | 76.50 |
Speciality | 410-41-136 | 1120 | 1120 | 57 | 342 | 816 | 328 | 380 | 108 | 865 | 57 | 57.00 |
Speciality | 410-41-330 | 1766 | 1766 | 20293 | 795 | 590 | 62 | 387 | 140 | 797 | 16 | 15.90 |
Speciality | 410-41-155 | 1529 | 1529 | 90 | 600 | 850 | 283 | 391 | 176 | 898 | 90 | 90.00 |
Tea Flavoured | 410-41-503/1 | 1651 | 1651 | 85 | 852 | 1105 | 254 | 396 | 0 | 1138 | 85 | 85.20 |
Tea Flavoured | 410-41-554/1 | 1345 | 1345 | 65 | 654 | 940 | 191 | 400 | 0 | 886 | 65 | 65.40 |
Speciality | 410-41-521/1 | 1511 | 1511 | 75 | 750 | 1107 | 299 | 407 | 0 | 1046 | 75 | 75.00 |
Speciality | 410-41-138 | 1202 | 1202 | 57 | 380 | 1306 | 780 | 417 | 108 | 1301 | 57 | 57.00 |
Tea Flavoured | 410-41-010 | 1767 | 1767 | 150 | 400 | 1362 | 664 | 480 | 218 | 1310 | 150 | 150.00 |
Speciality | 410-41-744 | 1147 | 574 | 4494 | 528 | 869 | 258 | 481 | 130 | 936 | 5 | 9.60 |
Speciality | 410-41-467 | 1013 | 1013 | 1254 | 200 | 1144 | 115 | 481 | 88 | 453 | 30 | 30.00 |
Speciality | 410-41-600/1 | 1293 | 1293 | 75 | 875 | 1133 | 238 | 503 | 0 | 1020 | 75 | 75.00 |
Speciality | 410-41-173 | 1865 | 1865 | 113 | 750 | 1248 | 519 | 505 | 224 | 1494 | 113 | 112.50 |
Tea Flavoured | 410-41-595 | 1241 | 1241 | 23 | 500 | 843 | 100 | 522 | 221 | 863 | 23 | 22.50 |
Speciality | 410-41-553/1 | 1382 | 1382 | 67 | 672 | 1133 | 246 | 529 | 0 | 992 | 67 | 67.20 |
Speciality | 410-41-328 | 2472 | 2472 | 28716 | 1125 | 834 | 86 | 549 | 198 | 1024 | 23 | 22.50 |
Speciality | 410-41-154 | 2003 | 2003 | 113 | 750 | 1208 | 438 | 550 | 220 | 1232 | 113 | 112.50 |
Speciality | 410-41-597 | 1869 | 1869 | 23 | 520 | 1335 | 553 | 552 | 230 | 1352 | 23 | 23.40 |
Speciality | 410-41-306 | 1005 | 1005 | 28595 | 300 | 855 | 95 | 579 | 23 | 817 | 30 | 30.00 |
Tea Flavoured | 410-41-159 | 2303 | 2303 | 126 | 840 | 1277 | 460 | 587 | 229 | 1436 | 126 | 126.00 |
Speciality | 410-41-160 | 1595 | 1595 | 93 | 558 | 1262 | 454 | 628 | 180 | 1150 | 93 | 93.00 |
Speciality | 410-41-004 | 2209 | 2209 | 225 | 600 | 1584 | 656 | 629 | 299 | 1689 | 225 | 225.00 |
Earl Grey | 410-41-805 | 1665 | 1665 | 60 | 144 | 1156 | 235 | 644 | 277 | 1250 | 60 | 60.00 |
Speciality | 410-41-013 | 2770 | 2770 | 204 | 544 | 1742 | 792 | 652 | 298 | 1758 | 204 | 204.00 |
Speciality | 410-41-005 | 2468 | 2468 | 225 | 600 | 2010 | 1056 | 654 | 299 | 2097 | 225 | 225.00 |
Speciality | 410-41-520/1 | 2044 | 2044 | 111 | 1110 | 1619 | 354 | 672 | 0 | 1433 | 111 | 111.00 |
Speciality | 410-41-312 | 2440 | 2440 | 150 | 900 | 1690 | 722 | 689 | 280 | 1771 | 150 | 150.00 |
Earl Grey | 410-41-108 | 2028 | 2028 | 131 | 783 | 1487 | 552 | 694 | 241 | 1551 | 131 | 130.50 |
Tea Flavoured | 410-41-509/1 | 2622 | 2622 | 128 | 1284 | 1609 | 226 | 697 | 0 | 1501 | 128 | 128.40 |
Fruit & Herb | 410-41-626 | 1501 | 1501 | 23 | 450 | 1077 | 137 | 705 | 234 | 1089 | 23 | 22.50 |
Fruit & Herb | 410-41-624 | 1501 | 1501 | 23 | 450 | 1147 | 164 | 708 | 275 | 1167 | 23 | 22.50 |
Fruit & Herb | 410-41-618 | 1531 | 1531 | 23 | 459 | 1207 | 232 | 737 | 239 | 1221 | 23 | 22.95 |
Speciality | 410-41-011 | 2471 | 2471 | 255 | 680 | 2348 | 1238 | 771 | 339 | 2242 | 255 | 255.00 |
Tea Flavoured | 410-41-594 | 1864 | 1864 | 34 | 750 | 1275 | 148 | 796 | 332 | 1331 | 34 | 33.75 |
Speciality | 410-41-592 | 1820 | 1820 | 34 | 750 | 1258 | 129 | 797 | 332 | 1266 | 34 | 33.75 |
Fruit & Herb | 410-41-185 | 2425 | 2425 | 90 | 612 | 1618 | 628 | 802 | 188 | 2006 | 90 | 89.76 |
Speciality | 410-41-803 | 2125 | 2125 | 79 | 189 | 1528 | 370 | 812 | 347 | 1529 | 79 | 78.75 |
Speciality | 410-41-541/1 | 2116 | 2116 | 105 | 1050 | 1783 | 396 | 827 | 0 | 1281 | 105 | 105.00 |
Speciality | 410-41-134 | 1940 | 1940 | 114 | 684 | 1614 | 543 | 865 | 206 | 1641 | 114 | 114.00 |
Tea Flavoured | 410-41-572 | 1731 | 1731 | 27 | 590 | 1467 | 163 | 886 | 418 | 1506 | 27 | 26.55 |
Speciality | 410-41-859/1 | 5349 | 5349 | 353 | 294 | 4232 | 1604 | 889 | 0 | 4188 | 353 | 352.80 |
Speciality | 410-41-807 | 2290 | 2290 | 86 | 207 | 1602 | 330 | 892 | 380 | 1615 | 86 | 86.25 |
Tea Flavoured | 410-41-573 | 1790 | 1790 | 27 | 610 | 1514 | 166 | 916 | 432 | 1539 | 27 | 27.45 |
Tea Flavoured | 410-41-574 | 1769 | 1769 | 27 | 610 | 1507 | 159 | 916 | 432 | 1445 | 27 | 27.45 |
Speciality | 410-41-951 | 3112 | 1037 | 20443 | 972 | 1785 | 516 | 940 | 328 | 2040 | 41 | 121.50 |
Speciality | 410-41-511/1 | 3334 | 3334 | 176 | 1758 | 2404 | 509 | 957 | 0 | 2256 | 176 | 175.80 |
Speciality | 410-41-860/1 | 4129 | 4129 | 295 | 246 | 3530 | 1100 | 974 | 0 | 3297 | 295 | 295.20 |
Tea Flavoured | 410-41-577 | 2028 | 2028 | 30 | 660 | 1739 | 281 | 991 | 467 | 1602 | 30 | 29.70 |
Speciality | 410-41-329 | 4635 | 4635 | 53986 | 2115 | 1566 | 162 | 1030 | 373 | 1977 | 42 | 42.30 |
Speciality | 410-41-591 | 2435 | 2435 | 45 | 1000 | 1675 | 172 | 1060 | 442 | 1682 | 45 | 45.00 |
Earl Grey | 410-41-593 | 2489 | 2489 | 45 | 1000 | 1678 | 176 | 1060 | 442 | 1776 | 45 | 45.00 |
Speciality | 410-41-003 | 4715 | 4715 | 375 | 1000 | 3383 | 1794 | 1090 | 499 | 3384 | 375 | 375.00 |
Speciality | 410-41-505/1 | 4076 | 4076 | 93 | 1854 | 2511 | 388 | 1134 | 0 | 2351 | 93 | 92.70 |
Speciality | 410-41-012 | 4627 | 4627 | 357 | 952 | 3593 | 1977 | 1141 | 475 | 3364 | 357 | 357.00 |
Tea Flavoured | 410-41-869/1 | 5382 | 5382 | 338 | 282 | 3408 | 597 | 1143 | 0 | 3325 | 338 | 338.40 |
Speciality | 410-41-131 | 3146 | 3146 | 153 | 918 | 2245 | 809 | 1161 | 276 | 2350 | 153 | 153.00 |
Earl Grey | 410-41-008 | 4278 | 4278 | 375 | 1000 | 3283 | 1585 | 1193 | 505 | 3431 | 375 | 375.00 |
Speciality | 410-41-620 | 2552 | 2552 | 38 | 765 | 1988 | 314 | 1198 | 476 | 2050 | 38 | 38.25 |
Speciality | 410-41-856/1 | 4067 | 4067 | 295 | 246 | 3590 | 936 | 1199 | 0 | 2827 | 295 | 295.20 |
Speciality | 410-41-952 | 2252 | 751 | 7990 | 855 | 1574 | 174 | 1205 | 195 | 1484 | 18 | 54.00 |
Earl Grey | 410-41-314 | 4428 | 4428 | 263 | 1575 | 2743 | 1052 | 1206 | 486 | 2892 | 263 | 262.50 |
Tea Flavoured | 410-41-601/1 | 3378 | 3378 | 180 | 2100 | 2517 | 368 | 1208 | 0 | 2339 | 180 | 180.00 |
Speciality | 410-41-105 | 3595 | 3595 | 240 | 1600 | 2783 | 1126 | 1223 | 433 | 2760 | 240 | 240.00 |
Decaf | 410-41-512/1 | 3471 | 3471 | 160 | 1596 | 3204 | 1096 | 1257 | 0 | 2682 | 160 | 159.60 |
Tea Flavoured | 410-41-857/1 | 4703 | 4703 | 310 | 258 | 3417 | 633 | 1257 | 0 | 3136 | 310 | 309.60 |
Speciality | 410-41-858/1 | 4404 | 4404 | 310 | 258 | 3886 | 1102 | 1257 | 0 | 3353 | 310 | 309.60 |
Speciality | 410-41-137 | 5675 | 5675 | 170 | 1017 | 5623 | 4005 | 1286 | 332 | 5531 | 170 | 169.50 |
Speciality | 410-41-501/1 | 5698 | 5698 | 288 | 2880 | 4164 | 1309 | 1318 | 0 | 4169 | 288 | 288.00 |
Speciality | 410-41-132 | 3513 | 3513 | 206 | 1233 | 2604 | 845 | 1389 | 370 | 2421 | 206 | 205.50 |
Speciality | 410-41-602/1 | 3714 | 3714 | 210 | 2450 | 3254 | 747 | 1409 | 0 | 2905 | 210 | 210.00 |
Tea Flavoured | 410-41-579 | 2981 | 2981 | 36 | 1000 | 2534 | 354 | 1493 | 687 | 2434 | 36 | 36.00 |
Fruit & Herb | 410-41-616 | 3302 | 3302 | 50 | 990 | 2253 | 231 | 1558 | 465 | 2253 | 50 | 49.50 |
Speciality | 410-41-507/1 | 5754 | 5754 | 309 | 3088 | 4453 | 1151 | 1655 | 0 | 4201 | 309 | 308.80 |
Speciality | 410-41-313 | 5875 | 5875 | 375 | 2250 | 3894 | 1472 | 1723 | 700 | 4139 | 375 | 375.00 |
Tea Flavoured | 410-41-576 | 3479 | 3479 | 44 | 1220 | 2918 | 278 | 1802 | 839 | 2936 | 44 | 43.92 |
Tea Flavoured | 410-41-504/1 | 5935 | 5935 | 300 | 3000 | 4049 | 614 | 1835 | 0 | 3727 | 300 | 300.00 |
Tea Flavoured | 410-41-009 | 9324 | 9324 | 675 | 1800 | 6014 | 3117 | 1962 | 935 | 5914 | 675 | 675.00 |
Speciality | 410-41-133 | 9505 | 9505 | 281 | 1683 | 5577 | 2943 | 2128 | 506 | 5365 | 281 | 280.50 |
Tea Flavoured | 410-41-575 | 4856 | 4856 | 68 | 1520 | 3930 | 609 | 2245 | 1076 | 3953 | 68 | 68.40 |
Speciality | 410-41-002 | 9652 | 9652 | 912 | 2432 | 7043 | 3483 | 2347 | 1213 | 7433 | 912 | 912.00 |
Speciality | 410-41-950 | 5384 | 1795 | 136341 | 2250 | 3874 | 573 | 2367 | 933 | 4309 | 45 | 135.00 |
Tea Flavoured | 410-41-006 | 9582 | 9582 | 819 | 2184 | 7180 | 3582 | 2381 | 1217 | 7829 | 819 | 819.00 |
Speciality | 410-41-130 | 5761 | 5761 | 336 | 2016 | 4371 | 1216 | 2549 | 606 | 3770 | 336 | 336.00 |
Fruit & Herb | 410-41-612 | 5374 | 5374 | 64 | 1611 | 3792 | 405 | 2585 | 801 | 3857 | 64 | 64.44 |
Speciality | 410-41-102 | 7531 | 7531 | 518 | 3450 | 5547 | 1976 | 2638 | 933 | 5115 | 518 | 517.50 |
Earl Grey | 410-41-007 | 10266 | 10266 | 882 | 2646 | 7320 | 3449 | 2684 | 1187 | 8074 | 882 | 882.00 |
Fruit & Herb | 410-41-622 | 5944 | 5944 | 71 | 1782 | 4136 | 615 | 2778 | 743 | 4417 | 71 | 71.28 |
Fruit & Herb | 410-41-610 | 6004 | 6004 | 72 | 1800 | 4500 | 693 | 2912 | 895 | 4601 | 72 | 72.00 |
Tea Flavoured | 410-41-181 | 7392 | 7392 | 14260 | 2568 | 5293 | 1315 | 3178 | 801 | 6048 | 257 | 256.80 |
Speciality | 410-41-606 | 8197 | 8197 | 68 | 2277 | 6425 | 1716 | 3629 | 1079 | 6327 | 68 | 68.31 |
Speciality | 410-41-001 | 14161 | 14161 | 1338 | 4014 | 10984 | 5123 | 4081 | 1779 | 11263 | 1338 | 1338.00 |
Fruit & Herb | 410-41-608 | 8976 | 8976 | 108 | 2691 | 6422 | 794 | 4290 | 1339 | 6732 | 108 | 107.64 |
Speciality | 410-41-101 | 14059 | 14059 | 966 | 5152 | 9737 | 3699 | 4297 | 1741 | 10593 | 966 | 966.00 |
Fruit & Herb | 410-41-212 | 19682 | 19682 | 669 | 4563 | 12649 | 5024 | 6219 | 1405 | 13267 | 669 | 669.24 |
Fruit & Herb | 410-41-614 | 15971 | 15971 | 239 | 4788 | 12123 | 1788 | 7358 | 2977 | 13613 | 239 | 239.40 |
Speciality | 410-41-502/1 | 23607 | 23607 | 1289 | 12888 | 18846 | 4087 | 7883 | 0 | 16891 | 1289 | 1288.80 |
Speciality | 410-41-508/1 | 45351 | 45351 | 2425 | 24252 | 36405 | 8632 | 14834 | 0 | 32313 | 2425 | 2425.20 |