Spreadsheet: 788580d1658558637-how-to-limit-number-of-rows-to-display-array_constrain-filter-constrain-aligw
Sheet: Filter Constrain

 |  |  |  |  |  |  | Current Result |  |  |  | Expected Result
 |  |  |  |  |  |  | [NAME]: | Save Mart
Order ID | Customer Name | Category | Product | Unit Price | Quantity |  | Product | Category | Price |  | Product | Category | Price |  | Product | Category | Price
1000364 | Albertsons | Pantry | Chocolate Cookies Mix | 9 | 70 |  |  | Beverage | 2.99 |  | Green Tea | Beverage | 2.99
1000365 | Safeway | Beverage | Coffee | 46 | 190 |  | Almonds | Pantry | 10 |  | Almonds | Pantry | 10
1000366 | Whole Foods | Pantry | Chocolate Cookies Mix | 9.2 | 470 |  | [NAME] | Pantry | 22 |  | [NAME] | Pantry | 22
1000367 | Safeway | Other | Shipping Only | 0 | 0 |  | [NAME] | Pantry | 9.2 |  | [NAME] | Pantry | 9.2
1000368 | Save Mart | Beverage | Green Tea | 2.99 | 900 |  | [NAME] | Pantry | 25 |  | [NAME] | Pantry | 25
1000369 | Smart & Final | Beverage | Soda | 14 | 100
1000370 | Save Mart | Pantry | Almonds | 10 | 810
1000371 | Food 4 Less | Pantry | Dried Plums | 3.5 | 750
1000372 | Safeway | Beverage | Coffee | 46 | 920
1000373 | Raley's | Pantry | Mozzarella | 34.8 | 180
1000374 | Vallarta | Pantry | [NAME] | 40 | 810
1000375 | Whole Foods | Pantry | Chocolate Cookies Mix | 9.2 | 380
1000376 | Food 4 Less | Pantry | Chocolate Cookies Mix | 9.2 | 880
1000377 | Save Mart | Pantry | [NAME] | 22 | 720
1000378 | [NAME] | Pantry | [NAME] | 40 | 250
1000379 | Whole Foods | Pantry | [NAME] | 40 | 820
1000380 | [NAME] | Pantry | Chocolate | 12.75 | 1000
1000381 | [NAME] | Pantry | [NAME] | 40 | 320
1000382 | Albertsons | Beverage | Lemonade | 18 | 640
1000383 | Food 4 Less | Pantry | Dried Pears | 30 | 810
1000384 | Whole Foods | Pantry | Chocolate | 12.75 | 360
1000385 | Whole Foods | Other | Shipping Only | 0 | 0
1000386 | Wal-Mart | Other | Shipping Only | 0 | 0
1000387 | Smart & Final | Pantry | Fruit Cocktail | 39 | 410
1000388 | Save Mart | Pantry | [NAME] | 9.2 | 600
1000389 | Mission Foods | Beverage | Lemonade | 18 | 810
1000390 | [NAME] | Beverage | Soda | 14 | 850
1000391 | Save Mart | Pantry | [NAME] | 25 | 840
1000392 | [NAME] | Pantry | Scones | 10 | 990
1000393 | [NAME] | Pantry | Chocolate | 12.75 | 410
1000394 | Ralphs | Pantry | [NAME] | 25 | 240
1000395 | Costco | Pantry | [NAME] | 40 | 290
1000396 | Albertsons | Beverage | Green Tea | 2.99 | 170
1000397 | [NAME] | Other | Shipping Only | 0 | 0
1000398 | Vons | Pantry | Dried Plums | 3.5 | 470
1000399 | Smart & Final | Pantry | Chocolate | 12.75 | 230
1000400 | Whole Foods | Pantry | Chocolate | 12.75 | 670
1000401 | Mission Foods | Beverage | Coffee | 46 | 440
1000402 | Vons | Pantry | Dried Plums | 3.5 | 600
1000403 | Costco | Pantry | Syrup | 10 | 490
1000404 | Food 4 Less | Pantry | Gnocchi | 38 | 330
1000405 | [NAME] | Pantry | Dried Apples | 53 | 680
1000406 | Smart & Final | Pantry | Chocolate | 12.75 | 940
1000407 | Wal-Mart | Beverage | Coffee | 46 | 640
1000408 | Vallarta | Pantry | Dried Plums | 3.5 | 670
1000409 | Safeway | Pantry | [NAME] | 9.65 | 380
1000410 | Ralphs | Pantry | Olive Oil | 21.35 | 490
1000411 | Mission Foods | Other | Shipping Only | 0 | 0
1000412 | Costco | Beverage | Green Tea | 2.99 | 120
1000413 | Costco | Pantry | [NAME] | 9.65 | 910
1000414 | Whole Foods | Pantry | Mozzarella | 34.8 | 290
1000415 | Safeway | Beverage | Coffee | 46 | 550
1000416 | Whole Foods | Pantry | [NAME] | 9.2 | 280
1000417 | Raley's | Pantry | Ravioli | 19.5 | 850
1000418 | Food 4 Less | Pantry | Dried Pears | 30 | 690
1000419 | Albertsons | Beverage | Coffee | 46 | 820
1000420 | Food 4 Less | Pantry | Marmalade | 81 | 620
1000421 | Smart & Final | Other | Shipping Only | 0 | 0
1000422 | Vons | Beverage | Soda | 14 | 490
1000423 | Save Mart | Pantry | Dried Plums | 3.5 | 960
1000424 | Whole Foods | Pantry | Chocolate | 12.75 | 470
1000425 | Food 4 Less | Pantry | Dried Apples | 53 | 830
1000426 | Albertsons | Pantry | Crab Meat | 18.4 | 880
1000427 | [NAME] | Pantry | Peanut Butter Biscuits | 22 | 740
1000428 | Mission Foods | Beverage | Lemonade | 18 | 970
1000429 | Ralphs | Pantry | Crab Meat | 18.4 | 990
1000430 | Food 4 Less | Other | Shipping Only | 0 | 0
1000431 | Vons | Beverage | Coffee | 14 | 190
1000432 | Safeway | Pantry | Crab Meat | 18.4 | 250
1000433 | Mission Foods | Beverage | Coffee | 46 | 610
1000434 | Save Mart | Beverage | Green Tea | 2.99 | 930
1000435 | [NAME] | Pantry | Dried Pears | 30 | 120
1000436 | Food 4 Less | Pantry | Peanut Butter Biscuits | 3.5 | 110
1000437 | Costco | Pantry | [NAME] | 9.65 | 890
1000438 | Vallarta | Beverage | Green Tea | 2.99 | 480
1000439 | Ralphs | Pantry | [NAME] | 9.65 | 720
1000440 | Vons | Other | Shipping Only | 0 | 0
1000441 | Food 4 Less | Pantry | Long Grain Rice | 7 | 910
1000442 | Raley's | Pantry | [NAME] | 9.65 | 340
1000443 | Food 4 Less | Pantry | Dried Apples | 53 | 890