The Table Filter macro supports filtration of table data in the page edit mode. You can also quickly filter your table data and add updates into the filtered entries.
To filter data while editing the page, switch to the editor, select the macro and click Show filter:
OrderDate | Region | Rep | Item | Units | Cost | Total | Delivery Address |
|---|---|---|---|---|---|---|---|
1/6/2020 | East | Jones | Pencil | 95 | 1.99 | 189.05 | Sumner Academy 1610 N 8th St, KS 66101 |
1/23/2020 | Central | Kivell | Binder | 50 | 19.99 | 999.50 | Elementary School, 2500 Wood Ave, KS 66104 |
2/9/2020 | Central | Jardine | Pencil | 36 | 4.99 | 179.64 | Bank of America, 1314 N 38th St, KS 66102 |
2/26/2020 | Central | Gill | Pen | 27 | 19.99 | 539.73 | AutoZone, 3400 State Ave, KS 66102 |
3/15/2020 | West | Sorvino | Pencil | 56 | 2.99 | 167.44 | Dollar General, 3716 State Ave, KS 66102 |
4/1/2020 | East | Johnson | Binder | 60 | 4.99 | 299.40 | Los Amigos, 2610 State Ave, KS 66102 |
4/18/2020 | Central | Andrews | Pencil | 75 | 1.99 | 149.25 | Wyandotte School, 2501 Minnesota Ave, KS 66102 |
5/5/2020 | Central | Jardine | Pencil | 90 | 4.99 | 449.10 | Bishop Ward High School, 708 N 18th St, KS 66102 |
5/22/2020 | West | Thompson | Pencil | 32 | 1.99 | 63.68 | Bishop Ward High School, 708 N 18th St, KS 66102 |
6/8/2020 | East | Jones | Binder | 60 | 8.99 | 539.40 | Elementary School, 2500 Wood Ave, KS 66104 |
6/25/2020 | Central | Morgan | Pencil | 90 | 4.99 | 449.10 | Sumner Academy 1610 N 8th St, KS 66101 |
7/12/2020 | East | Howard | Binder | 29 | 1.99 | 57.71 | Bishop Ward High School, 708 N 18th St, KS 66102 |
7/29/2020 | East | Parent | Binder | 81 | 19.99 | 1,619.19 | Bishop Ward High School, 708 N 18th St, KS 66102 |
8/15/2020 | East | Johnson | Pencil | 35 | 4.99 | 174.65 | Elementary School, 2500 Wood Ave, KS 66104 |
9/1/2020 | Central | Smith | Desk | 2 | 125.00 | 250.00 | Bank of America, 1314 N 38th St, KS 66102 |
9/18/2020 | East | Jones | Pen Set | 16 | 15.99 | 255.84 | Sumner Academy 1610 N 8th St, KS 66101 |
10/5/2020 | Central | Morgan | Binder | 28 | 8.99 | 251.72 | Elementary School, 2500 Wood Ave, KS 66104 |
10/22/2020 | East | Jones | Pen | 64 | 8.99 | 575.36 | Sumner Academy 1610 N 8th St, KS 66101 |
11/8/2020 | East | Parent | Pen | 15 | 19.99 | 299.85 | Sumner Academy 1610 N 8th St, KS 66101 |
11/25/2020 | Central | Kivell | Pen Set | 96 | 4.99 | 479.04 | Bishop Ward High School, 708 N 18th St, KS 66102 |
12/12/2020 | Central | Smith | Pencil | 67 | 1.29 | 86.43 | Bank of America, 1314 N 38th St, KS 66102 |
12/29/2020 | East | Parent | Pen Set | 74 | 15.99 | 1,183.26 | Bishop Ward High School, 708 N 18th St, KS 66102 |
1/15/2015 | Central | Gill | Binder | 46 | 8.99 | 413.54 | Bishop Ward High School, 708 N 18th St, KS 66102 |
2/1/2015 | Central | Smith | Binder | 87 | 15.00 | 1,305.00 | Sumner Academy 1610 N 8th St, KS 66101 |
2/18/2015 | East | Jones | Binder | 4 | 4.99 | 19.96 | Elementary School, 2500 Wood Ave, KS 66104 |
3/7/2015 | West | Sorvino | Binder | 7 | 19.99 | 139.93 | Sumner Academy 1610 N 8th St, KS 66101 |
3/24/2015 | Central | Jardine | Pen Set | 50 | 4.99 | 249.50 | Sumner Academy 1610 N 8th St, KS 66101 |
4/10/2015 | Central | Andrews | Pencil | 66 | 1.99 | 131.34 | Bank of America, 1314 N 38th St, KS 66102 |
4/27/2015 | East | Howard | Pen | 96 | 4.99 | 479.04 | Bishop Ward High School, 708 N 18th St, KS 66102 |
5/14/2015 | Central | Gill | Pencil | 53 | 1.29 | 68.37 | Los Amigos, 2610 State Ave, KS 66102 |
5/31/2015 | Central | Gill | Binder | 80 | 8.99 | 719.20 | Bishop Ward High School, 708 N 18th St, KS 66102 |
6/17/2015 | Central | Kivell | Desk | 5 | 125.00 | 625.00 | Bank of America, 1314 N 38th St, KS 66102 |
7/4/2015 | East | Jones | Pen Set | 62 | 4.99 | 309.38 | Sumner Academy 1610 N 8th St, KS 66101 |
7/21/2015 | Central | Morgan | Pen Set | 55 | 12.49 | 686.95 | Bishop Ward High School, 708 N 18th St, KS 66102 |
8/7/2015 | Central | Kivell | Pen Set | 42 | 23.95 | 1,005.90 | Los Amigos, 2610 State Ave, KS 66102 |
8/24/2015 | West | Sorvino | Desk | 3 | 275.00 | 825.00 | Bishop Ward High School, 708 N 18th St, KS 66102 |
9/10/2015 | Central | Gill | Pencil | 7 | 1.29 | 9.03 | Elementary School, 2500 Wood Ave, KS 66104 |
9/27/2015 | West | Sorvino | Pen | 76 | 1.99 | 151.24 | Sumner Academy 1610 N 8th St, KS 66101 |
10/14/2015 | West | Thompson | Binder | 57 | 19.99 | 1,139.43 | Elementary School, 2500 Wood Ave, KS 66104 |
10/31/2015 | Central | Andrews | Pencil | 14 | 1.29 | 18.06 | Sumner Academy 1610 N 8th St, KS 66101 |
11/17/2015 | Central | Jardine | Binder | 11 | 4.99 | 54.89 | Bishop Ward High School, 708 N 18th St, KS 66102 |
12/4/2015 | Central | Jardine | Binder | 94 | 19.99 | 1,879.06 | Los Amigos, 2610 State Ave, KS 66102 |
12/21/2015 | Central | Andrews | Binder | 28 | 4.99 | 139.72 | Bishop Ward High School, 708 N 18th St, KS 66102 |
| 12/5/2015 | West | Andrews | Desk | 25 | 5.00 | 125.00 | Bank of America, 1314 N 38th St, KS 66102 |
| 12/4/2015 | East | Jardine | Pencil | 10 | 6.00 | 60.00 | Los Amigos, 2610 State Ave, KS 66102 |