Spreadsheet: 724357d1616125518-count-based-on-a-colum-and-slicer-in-table-sales-per-region-test-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Centre
 |  | Count Region Customers greater than 0 based on salary |  |  |  |  |  |  |  | North
Slicer not required | Centre |  |  |  |  |  |  |  |  | South
Name | Region | Salary | Projection
[NAME] Holiday | South | 3100 | 7
[NAME] | South | 3000 | 6.9
[NAME] | South | 3800 | 20.5
[NAME] | South | 0 | 1
[NAME] | South | 0 | 30.6
[NAME] | South | 0 | 1.3
[NAME] | South | 0 | 10.2
[NAME] | South | 100 | 17
[NAME] | South | 0 | 38.4
[NAME] | South | 50 | 15.8
[NAME] | Centre | 0 | 44.2
[NAME] | Centre | 0 | 8
[NAME] | Centre | 3000 | 0.9
[NAME] | Centre | 4500 | 21.5
Bol Bol | Centre | 0 | 1.5
Bradley Beal | Centre | 9300 | 50.3
[NAME] | Centre | 5200 | 22.6
[NAME] | Centre | 4900 | 24.9
[NAME] | Centre | 4800 | 26.5
[NAME] | Centre | 0 | 11.1
[NAME] | Centre | 6400 | 32.6
[NAME] | Centre | 3000 | 1.7
[NAME] | Centre | 6800 | 35.1
[NAME] | Centre | 0 | 5.8
[NAME] | North | 3000 | 1.5
[NAME] | North | 0 | 14.4
[NAME] | North | 3000 | 1.4
[NAME] | North | 7100 | 32.4
[NAME] | North | 3000 | 2.3
[NAME] | North | 3000 | 0.8
[NAME] | North | 8500 | 25.1
[NAME] | North | 0 | 24.5
[NAME] | North | 3100 | 5.9
[NAME] | North | 0 | 23.3
[NAME] | North | 7400 | 35.6
[NAME] | North | 3500 | 17.7
Cristiano Felicio | North | 3000 | 1.7
[NAME] | North | 0 | 12.7
[NAME] | North | 3000 | 1.6
Damion Lee | North | 0 | 2.9
[NAME] | North | 3100 | 1.8
[NAME] | North | 3000 | 1.5
[NAME] | North | 4100 | 23.7
[NAME] | North | 4200 | 21.3
[NAME] | North | 5300 | 18.3
Daquan Jeffries | North | 3000 | 1
[NAME] | North | 6000 | 28.6
[NAME] | North | 3800 | 18.4
De'Aaron Fox | North | 9200 | 46.1
De'Anthony [NAME] | North | 4200 | 19.4
[NAME] | North | 3800 | 5.3
[NAME] | North | 5200 | 26.5
[NAME]' [NAME] | North | 4300 | 15.4
[NAME] | North | 3000 | 1.1
[NAME] | North | 7500 | 40.5
[NAME] | North | 5800 | 30.4
[NAME] | North | 4000 | 16.9
[NAME] | North | 0 | 15.9
Denzel Valentine | North | 3900 | 14.1
[NAME] | North | 0 | 29.5
[NAME] | North | 3800 | 13.6
[NAME] | North | 0 | 11.5
[NAME]' Graham | North | 4500 | 17.9
Dillon Brooks | North | 5600 | 25.2
Domantas Sabonis | North | 0 | 46.7
Donte DiVincenzo | North | 5200 | 23.5
[NAME] | North | 4600 | 19.9
Draymond Green | North | 0 | 32.9
[NAME] | North | 3100 | 15.7
[NAME] | North | 4800 | 22.7
[NAME] | North | 5800 | 26.5
[NAME] | North | 3100 | 10
[NAME] | North | 0 | 8
[NAME] | North | 3000 | 4.5
[NAME] | North | 3400 | 16.6
[NAME] | North | 0 | 15.9
[NAME] | North | 3000 | 10.9
[NAME] | North | 8100 | 26.1
[NAME] | North | 4200 | 12.3
[NAME] | North | 3000 | 6.7
Garrison Mathews | North | 3700 | 15.9
[NAME] | North | 11000 | 56.9
[NAME] | North | 3000 | 7.2
[NAME] | North | 5900 | 26.6
[NAME] | North | 7400 | 34.6
[NAME] | North | 3000 | 1
[NAME] | North | 3000 | 10.8
[NAME] | North | 3000 | 1
[NAME] | North | 6500 | 33.7
[NAME] | North | 4300 | 22.1
[NAME] | North | 3100 | 5.2
[NAME] | North | 3000 | 0.5
[NAME] | North | 3600 | 15.7
[NAME] | North | 3000 | 9.8
[NAME] | North | 3000 | 1.5
[NAME] | North | 3900 | 19.2
[NAME] | North | 4500 | 17.7
[NAME] | North | 7800 | 36.3
Jae'Sean [NAME] | North | 5400 | 30.1
[NAME] | North | 3000 | 1.7
[NAME] | North | 5900 | 32.3
[NAME] | North | 4700 | 22.6
[NAME] | North | 3000 | 1.5
[NAME] | North | 7600 | 36
[NAME] | North | 10900 | 68.4
[NAME] | North | 4600 | 27.2
JaMychal Green | North | 4300 | 23
[NAME] | North | 7700 | 36
[NAME] | North | 3200 | 17.6
[NAME] | North | 3100 | 1.6
[NAME] | North | 7700 | 40.2
[NAME] | North | 9200 | 44
[NAME] | North | 4200 | 21.7
[NAME] | North | 3000 | 11.8
Jerami Grant | North | 7300 | 37.9
[NAME] | North | 3300 | 7.4
[NAME] | North | 3000 | 1
[NAME] | North | 9700 | 44.4
[NAME] | North | 4700 | 24.3
[NAME] | North | 3000 | 1.3
[NAME] | North | 7600 | 38
[NAME] | North | 3500 | 16.5
[NAME] | North | 3000 | 2.8
[NAME] | North | 5100 | 29.8
[NAME] | North | 5200 | 23.4
Jrue Holiday | North | 6300 | 31.8
[NAME] | North | 0 | 2.6
Justin Holiday | North | 0 | 21.9
[NAME] | North | 0 | 8
[NAME] | North | 0 | 22.5
[NAME] | North | 0 | 19
[NAME] | North | 0 | 43.2
[NAME] | North | 0 | 1.2
[NAME] | North | 3000 | 1.5
[NAME] | North | 5100 | 27.6
[NAME] | North | 6700 | 24.1
[NAME] | North | 0 | 32.3
[NAME] | North | 4700 | 20.9
[NAME] | North | 3100 | 14.1
[NAME] | North | 6800 | 40.5
[NAME] | North | 3000 | 11.9
[NAME] | North | 7800 | 37.7
Killian Tillie | North | 0 | 0.5
[NAME] | North | 5200 | 28.4
Kristaps Porzingis | North | 8100 | 37.5
[NAME] | North | 5200 | 23.5
[NAME] | North | 3000 | 1.3
[NAME] | North | 8600 | 39.6
[NAME] | North | 3100 | 10.6
[NAME] | North | 3000 | 1.7
[NAME] | North | 8500 | 38.4
Landry Shamet | North | 3600 | 19.4
[NAME] | North | 4700 | 24.8
[NAME] | North | 5800 | 31.1
[NAME] | North | 4000 | 20
[NAME] | North | 4900 | 21.5
[NAME] | North | 10700 | 51.9
[NAME] | North | 3200 | 1.2
[NAME] | North | 3100 | 4.4
[NAME] | North | 3000 | 1.1
[NAME] | North | 7200 | 36
[NAME] | North | 4600 | 15.2
Marcus Morris Sr. | North | 4100 | 20.5
[NAME] | North | 5600 | 30.6
[NAME] | North | 3000 | 1.4
Mason Jones | North | 3100 | 12.8
Mason Plumlee | North | 6000 | 30.3
[NAME] | North | 3300 | 11.2
[NAME] | North | 3000 | 0.8
Maxi Kleber | North | 4200 | 20
[NAME] | North | 6700 | 30.7
[NAME] | North | 3100 | 5.5
[NAME] | North | 4500 | 21.3
[NAME] | North | 3000 | 0.6
[NAME] | North | 3000 | 0.3
Mychal Mulder | North | 3000 | 2.1
[NAME] | North | 5900 | 29.5
[NAME] | North | 3000 | 0.8
Nemanja Bjelica | North | 3700 | 20.3
[NAME] | North | 3000 | 1.2
Nico Mannion | North | 3000 | 13.8
[NAME] | North | 3900 | 17.5
[NAME] | North | 3500 | 17.7
Nikola Jokic | North | 10800 | 56.5
[NAME] | North | 7500 | 34.2
[NAME] | North | 4400 | 18.8
Pascal Siakam | North | 7300 | 26.4
[NAME] | North | 3800 | 15.8
[NAME] | North | 3000 | 0.6
[NAME] | North | 4700 | 19.6
[NAME] | North | 4300 | 22.9
[NAME] | North | 7900 | 41.4
[NAME] | North | 4400 | 17.5
[NAME] | North | 3000 | 1.3
Payton Pritchard | North | 3200 | 11.4
PJ Dozier | North | 3800 | 17.7
PJ Washington | North | 6500 | 27.6
Precious Achiuwa | North | 3500 | 1.5
Quinn Cook | North | 3000 | 8.3
[NAME] | North | 4100 | 18.6
[NAME] | North | 5100 | 22.4
[NAME] | North | 6700 | 35.1
[NAME] | North | 5600 | 27.7
[NAME] | North | 3200 | 14.5
[NAME] | North | 5200 | 22.6
[NAME] | North | 5800 | 26.9
[NAME] | North | 10400 | 56.3
[NAME] | North | 3000 | 3.9
[NAME] | North | 3600 | 15.8
[NAME] | North | 4900 | 24.9
[NAME] | North | 3000 | 1.6
[NAME] | North | 3000 | 0.5
[NAME] | North | 3000 | 11.3
[NAME] | North | 3000 | 14.1
[NAME] | North | 5100 | 24.3
[NAME] | North | 5400 | 25.4
[NAME] | North | 5700 | 22.1
[NAME] | North | 3900 | 12.9
[NAME] | North | 9800 | 49
Sterling Brown | North | 4600 | 27.6
[NAME] | North | 5200 | 21.2
Taurean Prince | North | 3100 | 9.4
[NAME] | North | 3200 | 9.6
[NAME] | North | 3600 | 16.9
[NAME] | North | 3000 | 0.8
[NAME] | North | 6700 | 30.2
Thaddeus Young | North | 6000 | 26.5
Thanasis Antetokounmpo | North | 3000 | 5.9
[NAME] | North | 4800 | 25.3
Timothe Luwawu-Cabarrot | North | 3100 | 14.9
[NAME] | North | 8400 | 43.1
[NAME] | North | 3800 | 23.2
[NAME] | North | 4000 | 19.2
[NAME] | North | 3000 | 1.6
Tre Jones | North | 3000 | 3
Tremont Waters | North | 3000 | 2.4
[NAME] | North | 3000 | 13
[NAME] | North | 3700 | 5.4
[NAME] | North | 3300 | 1.2
[NAME] | North | 5300 | 25.3
[NAME] | North | 3000 | 14.3
Tyrese Haliburton | North | 5500 | 32.6
Tyrese Maxey | North | 3400 | 1.9
Tyus Jones | North | 3200 | 14.3
Udonis Haslem | North | 3000 | 1.1
[NAME] | North | 3000 | 2
[NAME] | North | 3000 | 0.9
[NAME] | North | 5300 | 24.1
[NAME] | North | 3000 | 2.8
[NAME] | North | 5400 | 25.8
[NAME] | North | 3000 | 8
[NAME] | North | 3100 | 13.4
[NAME] | North | 3000 | 6.5
[NAME] | North | 8800 | 44.1
[NAME] | North | 3000 | 3.8