Spreadsheet: 699348d1602554093-dashboard-multiple-drop-down-criterias-with-sumifs-dashboard-testing
Sheet: Sheet2

 | Retail |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales District | Sales District
 | District | (All) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (All) | (All) | (All) |  |  |  |  | Sales District | 7001 - Windsor District | 7002 - London District | 7003 - Hamilton / Niagara | 7004 - Kitchener District
 | Store | (ALL) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store | 7001 |  |  | 1 |  |  | (All) | (ALL) | (ALL) | (ALL) | (ALL)
 | Fiscal Week | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-comm | 7002 |  |  |  |  |  | 7001 - Windsor District | 3052 | 3005 | 4054 | 3002
 | Fiscal Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7003 |  |  |  |  |  | 7002 - London District | 3053 | 3006 | 4055 | 3003
 | Fiscal Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7004 |  |  |  |  |  | 7003 - Hamilton / Niagara | 3054 | 3008 | 4056 | 3004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7005 |  |  |  |  |  | 7004 - Kitchener District | 3055 | 3009 | 4057 | 3007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7006 |  |  |  |  |  | 7005 - Ontario NE District | 3056 | 3010 | 4058 | 3011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7012 |  |  |  |  |  | 7006 - Ontario NW District | 3057 | 3041 | 4059 | 4003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7013 |  |  |  |  |  | 7012 - Brampton District | 3058 | 3042 | 4060 | 4004 | 3542 | 3552
 | Related Product Category | Sales $ | Sales $ vs. LW |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7014 |  |  |  |  |  | 7013 - GTA Central District | 3059 | 3102 | 4062 | 4005 | 3544 | 3553
 | Packaged Ice |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7016 |  |  |  |  |  | 7014 - GTA West District | 3116 | 3103 | 4063 | 4007 | 3601 | 3554
 | Nuts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7031 |  |  |  |  |  | 7016 - GTA East District | 3151 | 3104 | 4064 | 4008 | 3602 | 3556
 | Novelty |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7033 |  |  |  |  |  | 7031 - Ottawa District | 3152 | 3105 | 4070 | 4009 | 3603 | 3593
 | Men's Accessories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7034 |  |  |  |  |  | 7033 - Oshawa District | 3153 | 3106 | 4071 | 4040 | 3604 | 3594
 | PUMPS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7035 |  |  |  |  |  | 7034 - Barrie District | 3154 | 3107 | 4072 | 4065 | 3605 | 3641
 | Beverage Holders |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7191 |  |  |  |  |  | 7035 - Peterborough Distrct | 3156 | 3108 | 4073 | 4066 | 3607 | 3642
 | Giftware |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7191 - DC Operations | 3157 | 3110 | 4074 | 4069 | 3610 | 3652
 | Men's Eyewear |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3159 | 3111 | 4075 | 4076 | 3611 | 3653
 | Can Coolers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | District Name | Category |  |  |  |  |  | 3251 | 3112 | 4078 | 4077 | 3612 | 3654
 | Games |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (All) | (All) |  |  |  |  |  | 3252 | 3113 | 4079 | 4104 | 3613 | 3655
 | Pilot Merchandise |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windsor District | Packaged Ice |  |  |  |  |  | 3253 | 3114 | 4201 | 4114 | 3614 | 3656
 | Unisex Tops |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | London District | Nuts |  |  |  |  |  | 3254 | 3115 | 4203 | 4151 | 3702 | 3691
 | Glassware |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hamilton / Niagara | Novelty |  |  |  |  |  | 3255 | 3117 | 4204 | 4154 | 3703 | 3692
 | Drinkware Footed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kitchener District | Men's Accessories |  |  |  |  |  | 3256 | 3118 | 4205 | 4156 | 3741 | 3493
 | RP Value only |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ontario NE District | PUMPS |  |  |  |  |  | 3258 | 3119 | 4206 | 4157 | 3742 | 3591
 | Total RP Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ontario NW District | Beverage Holders |  |  |  |  |  | 3259 | 3139 | 4207 | 4158 | 3743 | 3693
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Brampton District | Giftware |  |  |  |  |  | 3260 | 3155 | 4208 | 4159 | 3744 | 4163
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GTA Central District | Men's Eyewear |  |  |  |  |  | 3262 | 3202 | 4209 | 4161 | 3745 | 4164
 |  | above sales $ should reflect on what District, store #, and fiscal week, month is selected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GTA West District | Can Coolers |  |  |  |  |  | 3263 | 3203 | 4210 | 4162 | 3503 | 4165
 |  | If all 3 is All, should sum up all $ sales by product |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GTA East District | Games |  |  |  |  |  | 3264 | 3204 | 4213 | 4166
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ottawa District | Pilot Merchandise |  |  |  |  |  | 3265 | 3205 | 4214 | 4167
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oshawa District | Unisex Tops |  |  |  |  |  | 3266 | 3206 | 4215 | 4168
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Barrie District | Glassware |  |  |  |  |  | 3267 | 3208 | 4216 | 4169
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peterborough Distrct | Drinkware Footed |  |  |  |  |  | 3268 | 3209 | 4217 | 4068
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DC Operations | RP Value only |  |  |  |  |  | 3291 | 3240 | 4218
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3191 | 3241 | 4219
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4220