Starting from version 3.3.0 Table Filter and Charts add-on supports filtration of table data in the page edit mode. Now besides management of filters while editing Confluence pages, you can also quickly filter your table data and add updates into the filtered entries.
To filter data while editing the page, follow these instructions:
- Switch the page to the edit mode.
- Click the body of Table Filter macro.
- On the appeared pane, click the Enable All Filters icon.
- Add new filters or use the existing filters.
- Select or specify the values for table filtration.
- To save updated filters and default values, click the Save Settings icon. Note that your modifications will be saved in the macro body and will be applied when you save the page.
You can also enable the automatic fitting of the table to the screen area, apply the appropriate sorting order to one or multiple table columns and regulate width of filter boxes.
OrderDate | Region | Rep | Item | Units | Cost | Total | Delivery Address |
---|---|---|---|---|---|---|---|
1/6/2014 | East | Jones | Pencil | 95 | 1.99 | 189.05 | Sumner Academy 1610 N 8th St, KS 66101 |
1/23/2014 | Central | Kivell | Binder | 50 | 19.99 | 999.50 | Elementary School, 2500 Wood Ave, KS 66104 |
2/9/2014 | Central | Jardine | Pencil | 36 | 4.99 | 179.64 | Bank of America, 1314 N 38th St, KS 66102 |
2/26/2014 | Central | Gill | Pen | 27 | 19.99 | 539.73 | AutoZone, 3400 State Ave, KS 66102 |
3/15/2014 | West | Sorvino | Pencil | 56 | 2.99 | 167.44 | Dollar General, 3716 State Ave, KS 66102 |
4/1/2014 | East | Johnson | Binder | 60 | 4.99 | 299.40 | Los Amigos, 2610 State Ave, KS 66102 |
4/18/2014 | Central | Andrews | Pencil | 75 | 1.99 | 149.25 | Wyandotte School, 2501 Minnesota Ave, KS 66102 |
5/5/2014 | Central | Jardine | Pencil | 90 | 4.99 | 449.10 | Bishop Ward High School, 708 N 18th St, KS 66102 |
5/22/2014 | West | Thompson | Pencil | 32 | 1.99 | 63.68 | Bishop Ward High School, 708 N 18th St, KS 66102 |
6/8/2014 | East | Jones | Binder | 60 | 8.99 | 539.40 | Elementary School, 2500 Wood Ave, KS 66104 |
6/25/2014 | Central | Morgan | Pencil | 90 | 4.99 | 449.10 | Sumner Academy 1610 N 8th St, KS 66101 |
7/12/2014 | East | Howard | Binder | 29 | 1.99 | 57.71 | Bishop Ward High School, 708 N 18th St, KS 66102 |
7/29/2014 | East | Parent | Binder | 81 | 19.99 | 1,619.19 | Bishop Ward High School, 708 N 18th St, KS 66102 |
8/15/2014 | East | Johnson | Pencil | 35 | 4.99 | 174.65 | Elementary School, 2500 Wood Ave, KS 66104 |
9/1/2014 | Central | Smith | Desk | 2 | 125.00 | 250.00 | Bank of America, 1314 N 38th St, KS 66102 |
9/18/2014 | East | Jones | Pen Set | 16 | 15.99 | 255.84 | Sumner Academy 1610 N 8th St, KS 66101 |
10/5/2014 | Central | Morgan | Binder | 28 | 8.99 | 251.72 | Elementary School, 2500 Wood Ave, KS 66104 |
10/22/2014 | East | Jones | Pen | 64 | 8.99 | 575.36 | Sumner Academy 1610 N 8th St, KS 66101 |
11/8/2014 | East | Parent | Pen | 15 | 19.99 | 299.85 | Sumner Academy 1610 N 8th St, KS 66101 |
11/25/2014 | Central | Kivell | Pen Set | 96 | 4.99 | 479.04 | Bishop Ward High School, 708 N 18th St, KS 66102 |
12/12/2014 | Central | Smith | Pencil | 67 | 1.29 | 86.43 | Bank of America, 1314 N 38th St, KS 66102 |
12/29/2014 | 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 |