| id | Buyer | Buyer Email | Seller | Seller Email | Subject Type | City | Transaction Date | Booking Date | Subtotal | Subtotal in USD | Credit Card Fee | Credit Card Fee in USD | Total | Total in USD | Payout | Payout in USD | Number of Guests | user_id | Cuisine | Style of Service |
| 5362b30fba4e705a0b000006 | Samantha Ressler | samantha.l.ressler@gmail.com | Daniel Benhaim | overtonemirror@gmail.com | Chef | la | 2014-05-01 20:48:15 UTC | 5/2/2014 | $960.00 | $960.00 | $10.80 | $10.80 | $370.80 | $370.80 | $864.00 | $864.00 | 12 | 53604043fac27ba73b000003 | American, Japanese | plated_meal |
| 5362b2b77177c305e7000002 | Stephanie Artner | stephanie.artner@gmail.com | Ozlem Oguzcan | o_oguzcan@hotmail.com | Chef | nyc | 2014-05-01 20:46:47 UTC | 5/14/2014 | $400.00 | $400.00 | $10.50 | $10.50 | $360.50 | $360.50 | $360.00 | $360.00 | 10 | 5344519d9a88d60e03000013 | Mediterranean, Turkish | family_style |
| 5362aba8bb0e613363000001 | 0 | alison.temple@fox.com | Deborah Gorman | deborahgorman@gmail.com | Chef | la | 2014-05-01 20:16:40 UTC | 5/18/2014 | $650.00 | $650.00 | $19.50 | $19.50 | $669.50 | $669.50 | $585.00 | $585.00 | 10 | 535ecdd32b17faf068000001 | Greek, Mediterranean | buffet |
| 53629a6d8005843f6f000001 | Deb Sheff | dslm@comcast.net | Brad Miller | braisedchicken58@yahoo.com | Chef | boston | 2014-05-01 19:03:09 UTC | 6/25/2014 | $160.00 | $160.00 | $4.80 | $4.80 | $164.80 | $164.80 | $144.00 | $144.00 | 2 | 5346fde17ff807af6c000001 | American, French | plated_meal |
| 5362995140f96b5c92000006 | Martha Arciszewski | martha.arciszewski@gmail.com | Ygael Tresser | ygael001@yahoo.com | nyc | 2014-05-01 18:58:25 UTC | 5/6/2014 | $300.00 | $300.00 | $9.00 | $9.00 | $309.00 | $309.00 | $270.00 | $270.00 | 5362617ea4d90ec0ce000034 | ||||
| 5362904fd67ee163bc000005 | Mitchell Seider | mitchell.seider@lw.com | Boris Dubnov | borisdubnov@me.com | Chef | nyc | 2014-05-01 18:19:59 UTC | 5/3/2014 | $864.00 | $864.00 | $25.92 | $25.92 | $889.92 | $889.92 | $777.60 | $777.60 | 12 | 535ea256b697d15970000014 | American | plated_meal |
| 53628226b020f15fdb000014 | Allison Heilborn | allison.heilborn@gmail.com | Christopher Lynch | goodfoodinc2@gmail.com | Chef | nyc | 2014-05-01 17:19:34 UTC | 5/17/2014 | $1,000.00 | $1,000.00 | $30.00 | $30.00 | $1,030.00 | $1,030.00 | $900.00 | $900.00 | 12 | 5340b8443f8a90365f00000e | American, Italian | family_style |
| 53627b644abe351b4b00002a | Susan Steinthal | susan.steinthal@citi.com | Lance Kindberg | cheflans888@gmail.com | Chef | nyc | 2014-05-01 16:50:44 UTC | 5/10/2014 | $700.00 | $700.00 | $21.00 | $21.00 | $721.00 | $721.00 | $630.00 | $630.00 | 14 | 535ab974d9192acf42000001 | American | buffet |
<colgroup><col><col span="6"><col><col><col span="12"></colgroup><tbody>
</tbody>
So here's my question. I want to filter out rows with any other city in the city column that is not LA. However, my understanding of the filter button --> deselect all --> LA is that it simply hides the rows, not delete them. The rows on the left side will then have large gaps, suggesting that the other cities (boston, NYc, etc.) are still in the data sheet, they are just hidden. Will this be a problem if I want to count the number of remaining rows that are LA-related rows?
I basically want to filter out the number of rows that do not have LA, and then count the remaining rows. How do I do this?
I tried using the count function, but it seems to only work with numbers?
-Jeff
