Spreadsheet: 821058d1678422956-help-regarding-formula-to-view-data-better-test-dmr
Sheet: data

 | Values | Date
 | Sum of mayo total |  |  |  |  | Sum of Rest sku |  |  |  |  | Sum of value tracker |  |  |  |  | Total Sum of mayo total | Total Sum of Rest sku | Total Sum of value tracker
Name of Customer | (blank) | 1/1/2023 - 1/8/2023 | 1/9/2023 - 1/16/2023 | 1/17/2023 - 1/24/2023 | 1/25/2023 - 2/1/2023 | (blank) | 1/1/2023 - 1/8/2023 | 1/9/2023 - 1/16/2023 | 1/17/2023 - 1/24/2023 | 1/25/2023 - 2/1/2023 | (blank) | 1/1/2023 - 1/8/2023 | 1/9/2023 - 1/16/2023 | 1/17/2023 - 1/24/2023 | 1/25/2023 - 2/1/2023
Sunday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19th may | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 seven | 0 | 0 | 0 | 0 | 408 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 32640 | 408 | 0 | 32640
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Any time [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
baba dairy | 0 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3924 | 0 | 0 | 0 | 36 | 0 | 3924
beach and brews | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
binny's kitchen | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
bm confectionary | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1920 | 0 | 0 | 12 | 0 | 1920
boston bites | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
boston bites 11 | 0 | 0 | 24 | 0 | 0 | 0 | 0 | 41 | 0 | 0 | 0 | 0 | 5701 | 0 | 0 | 24 | 41 | 5701
brown baking company | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
burger engineers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
burger point 67 | 0 | 0 | 0 | 0 | 48 | 0 | 0 | 0 | 0 | 68 | 0 | 0 | 0 | 0 | 12086 | 48 | 68 | 12086
burger uncle | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CFA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 12 | 0 | 12 | 0 | 0 | 24 | 0 | 12 | 0 | 0 | 4200 | 0 | 2700 | 0 | 24 | 36 | 6900
chicago pizza | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
cold fusion | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
culture | 0 | 0 | 0 | 0 | 0 | 0 | 36 | 0 | 0 | 0 | 0 | 4740 | 0 | 0 | 0 | 0 | 36 | 4740
da italine pizza | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Deepak fast food | 0 | 0 | 0 | 0 | 61 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 4185 | 61 | 1 | 4185
desi urban chai | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DLG | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
dominic pizza 40 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 256 | 0 | 0 | 0 | 0 | 29160 | 0 | 12 | 256 | 29160
dominic pizza 46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dominic pizza peer muschalla | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
dominic pizza shivjot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 144 | 0 | 0 | 0 | 0 | 19920 | 0 | 0 | 0 | 144 | 19920
dominick pizza shivjot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
dream bakers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
durga traders | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
first bite pizza | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
fish n chips | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36 | 0 | 0 | 0 | 0 | 5220 | 0 | 36 | 5220
food crunt | 0 | 0 | 0 | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2040 | 24 | 0 | 2040
foody hub | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 136 | 0 | 0 | 0 | 0 | 18516 | 0 | 12 | 136 | 18516
fortis hospital | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
fresh bite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 1905 | 0 | 0 | 0 | 15 | 1905
fun feast | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
gopal ji | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
grecian hospital | 0 | 24 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 3420 | 0 | 0 | 0 | 24 | 10 | 3420
guru snacks | 0 | 0 | 0 | 48 | 0 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 4155 | 0 | 48 | 9 | 4155
harpreet confectionary | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 120 | 0 | 0 | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 11280 | 0 | 120 | 60 | 11280
hunger hackers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
J&J | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
jogi mart | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
kansal brothers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
kansal sons | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | 0 | 5175 | 0 | 45 | 5175
katani's 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
laziz rasoi | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
le fruiteria | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
leave | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
lord of the drinks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
mahajan traders | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 30 | 14 | 20 | 0 | 2280 | 1620 | 2010 | 1080 | 0 | 86 | 6990
[NAME] holiday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
marwari bakery | 0 | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4080 | 0 | 60 | 0 | 4080
[NAME] hospital | 0 | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 62 | 0 | 0 | 0 | 0 | 8196 | 0 | 60 | 62 | 8196
[NAME] 10 | 0 | 0 | 24 | 0 | 0 | 0 | 0 | 12 | 0 | 26 | 0 | 0 | 4872 | 0 | 2726 | 24 | 38 | 7598
medical leave | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mirimal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
mk sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mom bakers 46 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 1361 | 1 | 22 | 1361
mona refreshment | 0 | 12 | 12 | 0 | 0 | 0 | 24 | 24 | 21 | 0 | 0 | 4200 | 5160 | 2775 | 0 | 24 | 69 | 12135
new cold fusion | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
new life trader | 0 | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 90 | 48 | 0 | 0 | 0 | 11988 | 6240 | 60 | 138 | 18228
nirola's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 1035 | 0 | 0 | 0 | 9 | 1035
Noor disposable | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] sweets | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
people net training | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
pgi canteen | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
pizza bite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
pizza buddy | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
pizza freakers | 0 | 0 | 0 | 0 | 54 | 0 | 0 | 300 | 0 | 305 | 0 | 0 | 41100 | 0 | 48589 | 54 | 605 | 89689
pizza galleria | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
pizza kitchen | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
pizza party point | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 132 | 0 | 0 | 0 | 0 | 18096 | 0 | 132 | 18096
pizza point | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
pizza sailorz phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 108 | 0 | 0 | 121 | 0 | 13500 | 0 | 0 | 15145 | 0 | 229 | 28645
pizza state | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
pokket [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
prankster | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
rai fast food | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 1500 | 0 | 0 | 0 | 12 | 1500
rana disposable | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 0 | 0 | 0 | 0 | 3000 | 0 | 0 | 24 | 3000
Republic day holiday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
rowdies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
sandburg | 0 | 0 | 72 | 0 | 0 | 0 | 0 | 42 | 0 | 0 | 0 | 0 | 15750 | 0 | 0 | 72 | 42 | 15750
shakes club | 0 | 24 | 12 | 0 | 0 | 0 | 12 | 12 | 21 | 0 | 0 | 4620 | 3660 | 2775 | 0 | 36 | 45 | 11055
Shobha juice bar | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
singh confectionary | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
slices of heaven | 0 | 0 | 0 | 8 | 12 | 0 | 0 | 0 | 78 | 79 | 0 | 0 | 0 | 12200 | 12715 | 20 | 157 | 24915
smaaash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
social | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
soya chap | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
the brew estate | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
the food corner | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
the great bear | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
the pizza bite 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
vaishnavi agencies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Vijay store | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
(blank) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total | 0 | 108 | 156 | 392 | 608 | 0 | 236 | 641 | 783 | 903 | 0 | 40884 | 104143 | 112835 | 167298 | 1264 | 2563 | 425160