Table Filter macro allows you to fit your large tables to your screen area, freeze rows and columns, add pagination, hide the unnecessary table columns and , apply static or dynamic row numbering and default sorting.
Fitting table to the screen area and freezing rows and columns
| Info |
|---|
Please note that the Table Filter macro allows you to automatically fit long tables to your screen area. |
| Table Filter |
|---|
| fixedCols | 2 |
|---|
| inverse | false,false,false |
|---|
| numbering | Dynamic Ascending |
|---|
| sparkName | Sparkline | numbering | true |
|---|
| column | Customer Status,Suspicious Transaction Activity,Target Transaction City |
|---|
| hidePane | Table header | id | 1457697373561_-187783312 |
|---|
| limitHeight | true1 |
|---|
| separator | Point (.) |
|---|
| labels | ‚‚ |
|---|
| default | ,, |
|---|
| isFirstTimeEnter | true |
|---|
| cell-width | ,, |
|---|
| datepattern | dd M yy |
|---|
| heightValue | 300 |
|---|
| id | 1612855498251_-684831433 |
|---|
| worklog | 365|5|8|y w d h m|y w d h m |
|---|
| isOR | AND |
|---|
| order | 0,1,2 |
|---|
|
| First Name | Last Name | Transaction amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number |
|---|
| Reuben | Barnett | $129.42 | Guápiles | Tunisia | Blocked | Yes | 8 | McKenzie | Cleveland | $216.75 | Savannah | United States | | First Name | Last Name | Transaction amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number |
|---|
| Reuben | Barnett | $129.42 | Guápiles | Tunisia | Blocked | Yes | 8 | | McKenzie | Cleveland | $216.75 | Savannah | United States | | Blocked | Yes | 1 | | Portia | Lang | $422.53 | Meerut | Côte D'Ivoire (Ivory Coast) | Rejected | No | 5 | | Eagan | Mcgee | $253.03 | Orangeville | Afghanistan | Approved | No | 2 | | Rahim | Velazquez | $454.06 | Lac-Serent | Georgia | Approved | Yes | 6 | | Roth | Hull | $142.57 | Luziânia | Sao Tome and Principe | Blocked | No | 4 | | Jack | Griffin | $146.60 | Georgia | Bahamas | Blocked | No | 4 | | Faith | Newton | $324.96 | Okigwe | Sri Lanka | Rejected | Yes | 1 | | Basia | Ray | $260.39 | Valcourt | Equatorial Guinea | Rejected | Yes | 4 | | Leandra | Duncan | $380.33 | My | Swaziland | Rejected | No | 6 | | Cameran | Velasquez | $144.75 | Schiltigheim | Bangladesh | Rejected | Yes | 8 | | Amery | Poole | $418.48 | Zolder | Azerbaijan | Rejected | Yes | 1 | | Owen | Welch | $279.12 | Springdale | Benin | Rejected | Yes | 4 | | Germaine | Hines | $347.08 | Bellingen | Algeria | Approved | No | 6 | | Thane | Cortez | $338.56 | Penrith | Tunisia | Approved | Yes | 1 | | Sean | Delacruz | $421.67 | Vietri di Potenza | Libya | Rejected | No | 4 | | Willow | Skinner | $216.70 | Ham-sur-Sambre | Venezuela | Approved | No | 1 | | Camilla | Good | $311.10 | Saint-Hilarion | Malawi | Rejected | No | 7 | | Ingrid | Horne | $365.20 | Crato | Dominica | Approved | Yes | 4 | | Claire | Raymond | $126.99 | Wieze | Western Sahara | Blocked | Yes | 9 | | Akeem | Holder | $131.59 | Sutton | Samoa | Blocked | Yes | 7 | | Yuli | Hubbard | $107.57 | Hudson Bay | Bolivia | Rejected | No | 4 | | Gregory | Sampson | $339.91 | Stroud | Mozambique | Blocked | No | 1 | | Freya | Osborn | $198.86 | Rexton | Luxembourg | Approved | Yes | 5 | | Kylan | Dillard | $264.70 | Market Drayton | Yemen | Rejected | No | 3 | | Curran | Dickson | $360.20 | San Francisco | Saint Martin | Blocked | No | 7 | | Sylvester | Campos | $338.44 | Riparbella | Armenia | Blocked | Yes | 5 | | Hadley | Gates | $363.39 | Chelmsford | New Zealand | Rejected | Yes | 7 | | Willa | Stevens | $137.89 | Glabais | Japan | Approved | No | 2 | | Keelie | Byers | $236.10 | Cavaion Veronese | Palestine, State of | Approved | No | 3 | | Jordan | Weber | $249.33 | Shepparton | Anguilla | Blocked | Yes | 9 | | Karly | Walls | $200.81 | Charlottetown | Guatemala | Approved | Yes | 7 | | Octavius | Cervantes | $235.63 | Merksem | Dominica | Approved | Yes | 4 | | Tyrone | Alvarez | $303.65 | Thame | Iraq | Blocked | Yes | 5 | | Jolene | Howe | $321.67 | Maple Creek | Togo | Blocked | No | 3 | | Cody | Ross | $219.44 | Gent | Austria | Blocked | Yes | 6 | | Chase | Bryant | $493.65 | Moustier-sur-Sambre | Czech Republic | Approved | No | 9 | | Lynn | Cummings | $484.17 | Metairie | Liechtenstein | Approved | No | 3 | | Lars | Shaw | $170.60 | Pittsburgh | British Indian Ocean Territory | Rejected | No | 4 | | Cassidy | Porter | $142.39 | Saint-Maur-des-Fossés | Zambia | Approved | Yes | 3 | | Whilemina | Goodwin | $255.81 | Amaro | Guinea | Rejected | No | 3 | | Jordan | Mullen | $151.41 | Alajuela | Eritrea | Approved | No | 9 | | Curran | Bond | $207.97 | Wattrelos | Belize | Approved | Yes | 4 | | Shad | Shelton | $177.90 | Salt Lake City | Estonia | Rejected | No | 4 | | Eve | Hines | $113.99 | Montpellier | Netherlands | Rejected | No | 7 | | Amir | Odom | $203.43 | Manavgat | Albania | Blocked | Yes | 5 | | Evan | Coffey | $489.53 | Prince Albert | Brunei | Rejected | No | 5 | | Quynn | King | $393.43 | São Luís | Chile | Blocked | No | 9 | | Ivy | Alvarado | $198.75 | Guwahati | Cape Verde | Approved | No | 2 | | Seth | Vasquez | $333.66 | Greater Hobart | Malaysia | Blocked | No | 3 | | Guy | Cotton | $168.20 | Saint-Pierre | Denmark | Blocked | No | 4 | | Xyla | Spears | $368.74 | Jamoigne | Guernsey | Rejected | No | 2 | | Haviva | Hancock | $136.33 | Chelsea | Zimbabwe | Approved | No | 5 | | Juliet | Barlow | $326.73 | Solingen | Iran | Approved | Yes | 7 | | Kay | Cole | $158.75 | Clare | Netherlands | Approved | Yes | 2 | | Zenaida | Kirkland | $315.19 | Yellowhead County | Mongolia | Blocked | No | 4 | | Ryan | Ware | $367.76 | Tuticorin | Armenia | Rejected | Yes | 8 | | Maite | Lowe | $256.17 | Muno | Poland | Blocked | No | 1 | | Sandra | Schultz | $273.51 | Nampa | Colombia | Approved | Yes | 9 | | Karina | Horton | $443.37 | Esslingen | Taiwan | Rejected | Yes | 2 | | Lysandra | Black | $322.36 | Strombeek-Bever | Swaziland | Blocked | Yes | 8 | | Alden | Buckner | $249.18 | San Marcello Pistoiese | Hungary | Blocked | No | 1 | | Levi | Nolan | $478.53 | Chambord | Ukraine | Rejected | No | 7 | | Buckminster | Ewing | $239.77 | Haren | Argentina | Blocked | No | 1 | | Aidan | Henson | $340.93 | Valpelline | Jersey | Approved | No | 3 | | Howard | Crosby | $201.61 | Chambave | Cameroon | Blocked | No | 2 | | Ginger | Castro | $473.40 | Isle-aux-Coudres | Latvia | Approved | No | 4 | | Hyatt | Mullins | $450.40 | Oldenzaal | Slovenia | Rejected | No | 4 | | Rachel | Head | $166.15 | Bautzen | Nauru | Blocked | No | 7 | | Shoshana | Underwood | $336.12 | Parkland County | Liechtenstein | Blocked | No | 2 | | Colt | Kent | $482.74 | Jalgaon | Grenada | Approved | Yes | 3 | | Amethyst | Dunn | $313.64 | Dipignano | Western Sahara | Approved | Yes | 9 | | Plato | Duke | $229.55 | Exeter | India | Blocked | Yes | 1 | | Jared | Dale | $391.90 | Béziers | Mauritius | Approved | Yes | 3 | | Luke | Vang | $375.44 | Vorselaar | Jersey | Blocked | Yes | 1 | | Phillip | Reed | $431.70 | Chittoor | Christmas Island | Approved | Yes | 6 | | Brandon | Lowery | $213.54 | Cork | Chad | Rejected | Yes | 1 | | Rafael | Elliott | $281.05 | Little Rock | Jamaica | Approved | Yes | 4 | | Lyle | Black | $437.51 | Mold | Palau | Rejected | Yes | 6 | | Wendy | Rosa | $219.66 | Fortaleza | Egypt | Approved | No | 7 | | Priscilla | Dodson | $414.83 | Polpenazze del Garda | Christmas Island | Approved | Yes | 1 | | Quamar | Crawford | $465.99 | Treglio | Suriname | Blocked | Yes | 2 | | Shad | Flores | $442.84 | Vezirköprü | Guyana | Blocked | Yes | 6 | | Lana | Wheeler | $202.64 | St. Neots | Palau | Rejected | No | 1 | | Vanna | Farmer | $351.21 | Millport | Maldives | Approved | Yes | 9 | | Cadman | Ray | $352.24 | Cheyenne | South Sudan | Blocked | No | 7 | | Kimberley | Savage | $429.55 | Miami | Vanuatu | Approved | No | 9 | | Armand | Sears | $477.13 | Mussy-la-Ville | Saint Vincent and The Grenadines | Approved | No | 8 | | Sawyer | Vance | $492.63 | Davoli | Benin | Rejected | No | 4 | | Tanek | Lyons | $172.85 | Rocky View | Afghanistan | Approved | No | 9 | | Nayda | Hickman | $295.47 | Newcastle-upon-Tyne | Kiribati | Blocked | No | 3 | | Aileen | Waters | $202.47 | Idar-Oberstei | Slovakia | Blocked | Yes | 3 | | Forrest | Larsen | $269.64 | Gulfport | Korea, North | Blocked | Yes | 3 | | Willa | Kemp | $239.89 | Somma Lombardo | Wallis and Futuna | Approved | Yes | 2 | | Eugenia | Byrd | $466.08 | Caruaru | Northern Mariana Islands | Rejected | Yes | 8 | | Kato | Beck | $396.49 | Khanpur | Solomon Islands | Approved | Yes | 2 |
|
Hiding table columns
| Info |
|---|
Please note that Table Filter macro allows you to hide columns if you have a too wide table. Select one or multiple columns to hide in the table below. |
Adding the pagination
| tabletable-filter |
|---|
| inverse | false,false,false |
|---|
| numbering | Dynamic Ascending |
|---|
| sparkName | Sparkline |
|---|
| column | Customer Status,Suspicious Transaction Activity,Target Transaction City |
|---|
| hidePane | Table header |
|---|
| rowsPerPage | 5 |
|---|
| default | Customer Status |
|---|
| hideColumns | true |
|---|
| cell-width | 150 |
|---|
| datepattern | yy-mm-dd |
|---|
| id | 1457700769494_-1817234935 |
|---|
| separator | Point (.) |
|---|
| First Name | Last Name| ‚‚ | | default | ,, |
|---|
| isFirstTimeEnter | true |
|---|
| cell-width | ,, |
|---|
| datepattern | dd M yy |
|---|
| id | 1612855440831_-731515321 |
|---|
| worklog | 365|5|8|y w d h m|y w d h m |
|---|
| isOR | AND |
|---|
| order | 0,1,2 |
|---|
|
| Contact Phones | Last Transaction Date | Bank Account Number | Transaction amount | Tax Amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number | | Reuben | Barnett | 0500 009888 | 12/14/14 | DO07819385109432271545550865 | $129.42 | $10.28 | Guápiles | Tunisia | Blocked | Yes | 8 | McKenzie | Cleveland | 07624 785373 | 09/15/14 | CH6046131558340157475 | $216.75 | $46.19 | | First Name | Last Name | Transaction amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number |
|---|
| Reuben | Barnett | $129.42 | Guápiles | Tunisia | Blocked | Yes | 8 | | McKenzie | Cleveland | $216.75 | | Savannah | United States | Blocked | Yes | 1 | | Portia | Lang |
(011247) 0442009/27/14 | EE967962637165872502 | $16.29 | | Meerut | Côte D'Ivoire (Ivory Coast) | Rejected | No | 5 | | Eagan | Mcgee |
07212 430492 | 09/19/14MK83589588636375406 | $26.26 | | Orangeville | Afghanistan | Approved | No | 2 | | Rahim | Velazquez |
0325 526 8440 | 12/31/14 | FO0682149824230550 | $454.06 | $27.73 | Lac| -Serent | Georgia | Approved | Yes | 6 | | Roth | Hull |
0500 311844 | 10/11/14 | LU056987267796106873 | $14.14 | | Luziânia | Sao Tome and Principe | Blocked | No | 4 | | Jack | Griffin |
07624 30748809/04/14 | BA714509342088998370 | $34.55 | | Georgia | Bahamas | Blocked | No | 4 | | Faith | Newton |
0800 1111 | 09/24/14LU521764205226552485 | $24.60 | | Okigwe | Sri Lanka | Rejected | Yes | 1 | | Basia | Ray |
0346 983 8340 | 08/13/14 | TR280491289079508593611789 | $260.39 | $45.19 | Valcourt | | $260.39 | Valcourt | Equatorial Guinea | Rejected | Yes | 4 | | Leandra | Duncan |
0359 889 6822 | 01/11/15 | CR0942393063075420342 | $34.57 |
Using Automatic Row Numbering
| Info |
|---|
Please note that Table Filter macro allows you to enable automatic row numbering and regulate the direction of numbering (ascending or descending). Additionally, you can use dynamic or static row numbering when filtering table data. |
Table with dynamic row numbering
| Table Filter |
|---|
| numbering | Dynamic Ascending |
|---|
| default | Blocked,Yes |
|---|
| cell-width | 150,150 |
|---|
| column | Customer Status,Suspicious Transaction Activity |
|---|
| datepattern | yy-mm-dd |
|---|
| id | 1457697957795_-202726414 |
|---|
| separator | Point (.) |
|---|
|
First Name | Last Name | Transaction amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number | Reuben | Barnett | $129.42 | Guápiles | Tunisia | Blocked | Yes | 8 | McKenzie | Cleveland | $216.75 | Savannah | United States | Blocked | Yes | 1 | Portia | Lang | $422.53 | Meerut | Côte D'Ivoire (Ivory Coast) | Rejected | No | 5 | Eagan | Mcgee | $253.03 | Orangeville | Afghanistan | Approved | No | 2 | Rahim | Velazquez | $454.06 | Lac-Serent | Georgia | Approved | Yes | 6 | Roth | Hull | $142.57 | Luziânia | Sao Tome and Principe | Blocked | No | 4 | Jack | Griffin | $146.60 | Georgia | Bahamas | Blocked | No | 4 | Faith | Newton | $324.96 | Okigwe | Sri Lanka | Rejected | Yes | 1 | Basia | Ray | $260.39 | Valcourt | Equatorial Guinea | Rejected | Yes | 4 | Leandra | Duncan | $380.33 | My | Swaziland | Rejected | No | 6 | Cameran | Velasquez | $144.75 | Schiltigheim | Bangladesh | Rejected | Yes | 8 | Amery | Poole | $418.48 | Zolder | Azerbaijan | Rejected | Yes | 1 | Owen | Welch | $279.12 | Springdale | Benin | Rejected | Yes | 4 | Germaine | Hines | $347.08 | Bellingen | Algeria | Approved | No | 6 | Thane | Cortez | $338.56 | Penrith | Tunisia | Approved | Yes | 1 | Sean | Delacruz | $421.67 | Vietri di Potenza | Libya | Rejected | No | 4 | Willow | Skinner | $216.70 | Ham-sur-Sambre | Venezuela | Approved | No | 1 | Camilla | Good | $311.10 | Saint-Hilarion | Malawi | Rejected | No | 7 | Ingrid | Horne | $365.20 | Crato | Dominica | Approved | Yes | 4 | Claire | Raymond | $126.99 | Wieze | Western Sahara | Blocked | Yes | 9 | Akeem | Holder | $131.59 | Sutton | Samoa | Blocked | Yes | 7 | Yuli | Hubbard | $107.57 | Hudson Bay | Bolivia | Rejected | No | 4 | Gregory | Sampson | $339.91 | Stroud | Mozambique | Blocked | No | 1 | Freya | Osborn | $198.86 | Rexton | Luxembourg | Approved | Yes | 5 | Kylan | Dillard | $264.70 | Market Drayton | Yemen | Rejected | No | 3 | Curran | Dickson | $360.20 | San Francisco | Saint Martin | Blocked | No | 7 | Sylvester | Campos | $338.44 | Riparbella | Armenia | Blocked | Yes | 5 | Hadley | Gates | $363.39 | Chelmsford | New Zealand | Rejected | Yes | 7 | Willa | Stevens | $137.89 | Glabais | Japan | Approved | No | 2 | Keelie | Byers | $236.10 | Cavaion Veronese | Palestine, State of | Approved | No | 3 | Jordan | Weber | $249.33 | Shepparton | Anguilla | Blocked | Yes | 9 | Karly | Walls | $200.81 | Charlottetown | Guatemala | Approved | Yes | 7 | Octavius | Cervantes | $235.63 | Merksem | Dominica | Approved | Yes | 4 | Tyrone | Alvarez | $303.65 | Thame | Iraq | Blocked | Yes | 5 | Jolene | Howe | $321.67 | Maple Creek | Togo | Blocked | No | 3 | Cody | Ross | $219.44 | Gent | Austria | Blocked | Yes | 6 | Chase | Bryant | $493.65 | Moustier-sur-Sambre | Czech Republic | Approved | No | 9 | Lynn | Cummings | $484.17 | Metairie | Liechtenstein | Approved | No | 3 | Lars | Shaw | $170.60 | Pittsburgh | British Indian Ocean Territory | Rejected | No | 4 | Cassidy | Porter | $142.39 | Saint-Maur-des-Fossés | Zambia | Approved | Yes | 3 |
|
Table with static row numbering
| Cameran | Velasquez | $144.75 | Schiltigheim | Bangladesh | Rejected | Yes | 8 | | Amery | Poole | $418.48 | Zolder | Azerbaijan | Rejected | Yes | 1 | | Owen | Welch | $279.12 | Springdale | Benin | Rejected | Yes | 4 | | Germaine | Hines | $347.08 | Bellingen | Algeria | Approved | No | 6 | | Thane | Cortez | $338.56 | Penrith | Tunisia | Approved | Yes | 1 | | Sean | Delacruz | $421.67 | Vietri di Potenza | Libya | Rejected | No | 4 | | Willow | Skinner | $216.70 | Ham-sur-Sambre | Venezuela | Approved | No | 1 | | Camilla | Good | $311.10 | Saint-Hilarion | Malawi | Rejected | No | 7 | | Ingrid | Horne | $365.20 | Crato | Dominica | Approved | Yes | 4 | | Claire | Raymond | $126.99 | Wieze | Western Sahara | Blocked | Yes | 9 | | Akeem | Holder | $131.59 | Sutton | Samoa | Blocked | Yes | 7 | | Yuli | Hubbard | $107.57 | Hudson Bay | Bolivia | Rejected | No | 4 | | Gregory | Sampson | $339.91 | Stroud | Mozambique | Blocked | No | 1 | | Freya | Osborn | $198.86 | Rexton | Luxembourg | Approved | Yes | 5 | | Kylan | Dillard | $264.70 | Market Drayton | Yemen | Rejected | No | 3 | | Curran | Dickson | $360.20 | San Francisco | Saint Martin | Blocked | No | 7 | | Sylvester | Campos | $338.44 | Riparbella | Armenia | Blocked | Yes | 5 | | Hadley | Gates | $363.39 | Chelmsford | New Zealand | Rejected | Yes | 7 | | Willa | Stevens | $137.89 | Glabais | Japan | Approved | No | 2 | | Keelie | Byers | $236.10 | Cavaion Veronese | Palestine, State of | Approved | No | 3 | | Jordan | Weber | $249.33 | Shepparton | Anguilla | Blocked | Yes | 9 | | Karly | Walls | $200.81 | Charlottetown | Guatemala | Approved | Yes | 7 | | Octavius | Cervantes | $235.63 | Merksem | Dominica | Approved | Yes | 4 | | Tyrone | Alvarez | $303.65 | Thame | Iraq | Blocked | Yes | 5 | | Jolene | Howe | $321.67 | Maple Creek | Togo | Blocked | No | 3 | | Cody | Ross | $219.44 | Gent | Austria | Blocked | Yes | 6 | | Chase | Bryant | $493.65 | Moustier-sur-Sambre | Czech Republic | Approved | No | 9 | | Lynn | Cummings | $484.17 | Metairie | Liechtenstein | Approved | No | 3 | | Lars | Shaw | $170.60 | Pittsburgh | British Indian Ocean Territory | Rejected | No | 4 | | Cassidy | Porter | $142.39 | Saint-Maur-des-Fossés | Zambia | Approved | Yes | 3 | | Whilemina | Goodwin | $255.81 | Amaro | Guinea | Rejected | No | 3 | | Jordan | Mullen | $151.41 | Alajuela | Eritrea | Approved | No | 9 | | Curran | Bond | $207.97 | Wattrelos | Belize | Approved | Yes | 4 | | Shad | Shelton | $177.90 | Salt Lake City | Estonia | Rejected | No | 4 | | Eve | Hines | $113.99 | Montpellier | Netherlands | Rejected | No | 7 | | Amir | Odom | $203.43 | Manavgat | Albania | Blocked | Yes | 5 | | Evan | Coffey | $489.53 | Prince Albert | Brunei | Rejected | No | 5 | | Quynn | King | $393.43 | São Luís | Chile | Blocked | No | 9 | | Ivy | Alvarado | $198.75 | Guwahati | Cape Verde | Approved | No | 2 | | Seth | Vasquez | $333.66 | Greater Hobart | Malaysia | Blocked | No | 3 | | Guy | Cotton | $168.20 | Saint-Pierre | Denmark | Blocked | No | 4 | | Xyla | Spears | $368.74 | Jamoigne | Guernsey | Rejected | No | 2 | | Haviva | Hancock | $136.33 | Chelsea | Zimbabwe | Approved | No | 5 | | Juliet | Barlow | $326.73 | Solingen | Iran | Approved | Yes | 7 | | Kay | Cole | $158.75 | Clare | Netherlands | Approved | Yes | 2 | | Zenaida | Kirkland | $315.19 | Yellowhead County | Mongolia | Blocked | No | 4 | | Ryan | Ware | $367.76 | Tuticorin | Armenia | Rejected | Yes | 8 | | Maite | Lowe | $256.17 | Muno | Poland | Blocked | No | 1 | | Sandra | Schultz | $273.51 | Nampa | Colombia | Approved | Yes | 9 | | Karina | Horton | $443.37 | Esslingen | Taiwan | Rejected | Yes | 2 | | Lysandra | Black | $322.36 | Strombeek-Bever | Swaziland | Blocked | Yes | 8 | | Alden | Buckner | $249.18 | San Marcello Pistoiese | Hungary | Blocked | No | 1 | | Levi | Nolan | $478.53 | Chambord | Ukraine | Rejected | No | 7 | | Buckminster | Ewing | $239.77 | Haren | Argentina | Blocked | No | 1 | | Aidan | Henson | $340.93 | Valpelline | Jersey | Approved | No | 3 | | Howard | Crosby | $201.61 | Chambave | Cameroon | Blocked | No | 2 | | Ginger | Castro | $473.40 | Isle-aux-Coudres | Latvia | Approved | No | 4 | | Hyatt | Mullins | $450.40 | Oldenzaal | Slovenia | Rejected | No | 4 | | Rachel | Head | $166.15 | Bautzen | Nauru | Blocked | No | 7 | | Shoshana | Underwood | $336.12 | Parkland County | Liechtenstein | Blocked | No | 2 | | Colt | Kent | $482.74 | Jalgaon | Grenada | Approved | Yes | 3 | | Amethyst | Dunn | $313.64 | Dipignano | Western Sahara | Approved | Yes | 9 | | Plato | Duke | $229.55 | Exeter | India | Blocked | Yes | 1 | | Jared | Dale | $391.90 | Béziers | Mauritius | Approved | Yes | 3 | | Luke | Vang | $375.44 | Vorselaar | Jersey | Blocked | Yes | 1 | | Phillip | Reed | $431.70 | Chittoor | Christmas Island | Approved | Yes | 6 | | Brandon | Lowery | $213.54 | Cork | Chad | Rejected | Yes | 1 | | Rafael | Elliott | $281.05 | Little Rock | Jamaica | Approved | Yes | 4 | | Lyle | Black | $437.51 | Mold | Palau | Rejected | Yes | 6 | | Wendy | Rosa | $219.66 | Fortaleza | Egypt | Approved | No | 7 | | Priscilla | Dodson | $414.83 | Polpenazze del Garda | Christmas Island | Approved | Yes | 1 | | Quamar | Crawford | $465.99 | Treglio | Suriname | Blocked | Yes | 2 | | Shad | Flores | $442.84 | Vezirköprü | Guyana | Blocked | Yes | 6 | | Lana | Wheeler | $202.64 | St. Neots | Palau | Rejected | No | 1 | | Vanna | Farmer | $351.21 | Millport | Maldives | Approved | Yes | 9 | | Cadman | Ray | $352.24 | Cheyenne | South Sudan | Blocked | No | 7 | | Kimberley | Savage | $429.55 | Miami | Vanuatu | Approved | No | 9 | | Armand | Sears | $477.13 | Mussy-la-Ville | Saint Vincent and The Grenadines | Approved | No | 8 | | Sawyer | Vance | $492.63 | Davoli | Benin | Rejected | No | 4 | | Tanek | Lyons | $172.85 | Rocky View | Afghanistan | Approved | No | 9 | | Nayda | Hickman | $295.47 | Newcastle-upon-Tyne | Kiribati | Blocked | No | 3 | | Aileen | Waters | $202.47 | Idar-Oberstei | Slovakia | Blocked | Yes | 3 | | Forrest | Larsen | $269.64 | Gulfport | Korea, North | Blocked | Yes | 3 | | Willa | Kemp | $239.89 | Somma Lombardo | Wallis and Futuna | Approved | Yes | 2 | | Eugenia | Byrd | $466.08 | Caruaru | Northern Mariana Islands | Rejected | Yes | 8 | | Kato | Beck | $396.49 | Khanpur | Solomon Islands | Approved | Yes | 2 |
|
Hiding table columns
| Info |
|---|
Please note that Table Filter macro allows you to hide columns if you have a too wide table. Select one or multiple columns to hide in the table below. |
| Table Filter |
|---|
| inverse | false |
|---|
| default | Customer Status&&Bank Account Number |
|---|
| cell-width | 150 |
|---|
| hideColumns | true |
|---|
| hidePane | Filtration panel |
|---|
| datepattern | yy-mm-dd |
|---|
| id | 1457700769494_-1817234935 |
|---|
| separator | Point (.) |
|---|
| labels | Hide Columns |
|---|
| order | 0 |
|---|
|
| First Name | Last Name | Contact Phones | Last Transaction Date | Bank Account Number | Transaction amount | Tax Amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number |
|---|
| Reuben | Barnett | 0500 009888 | 12/20/20 | DO07819385109432271545550865 | $129.42 | $10.28 | Guápiles | Tunisia | Blocked | Yes | 8 | | McKenzie | Cleveland | 07624 785373 | 09/21/20 | CH6046131558340157475 | $216.75 | $46.19 | Savannah | United States | Blocked | Yes | 1 | | Portia | Lang | (011247) 04420 | 09/27/20 | EE967962637165872502 | $422.53 | $16.29 | Meerut | Côte D'Ivoire (Ivory Coast) | Rejected | No | 5 | | Eagan | Mcgee | 07212 430492 | 09/19/20 | MK83589588636375406 | $253.03 | $26.26 | Orangeville | Afghanistan | Approved | No | 2 | | Rahim | Velazquez | 0325 526 8440 | 12/31/20 | FO0682149824230550 | $454.06 | $27.73 | Lac-Serent | Georgia | Approved | Yes | 6 | | Roth | Hull | 0500 311844 | 10/11/20 | LU056987267796106873 | $142.57 | $14.14 | Luziânia | Sao Tome and Principe | Blocked | No | 4 | | Jack | Griffin | 07624 307488 | 09/04/20 | BA714509342088998370 | $146.60 | $34.55 | Georgia | Bahamas | Blocked | No | 4 | | Faith | Newton | 0800 1111 | 09/24/20 | LU521764205226552485 | $324.96 | $24.60 | Okigwe | Sri Lanka | Rejected | Yes | 1 | | Basia | Ray | 0346 983 8340 | 08/13/20 | TR280491289079508593611789 | $260.39 | $45.19 | Valcourt | Equatorial Guinea | Rejected | Yes | 4 | | Leandra | Duncan | 0359 889 6822 | 01/11/21 | CR0942393063075420342 | $380.33 | $34.57 | My | Swaziland | Rejected | No | 6 |
|
Using Automatic Row Numbering and Default Sorting
| Info |
|---|
Please note that the Table Filter macro allows you to enable automatic row numbering and regulate the direction of numbering (ascending or descending). Additionally, you can default sorting by one or multiple columns. |
| Table Filter |
|---|
| inverse | false,false |
|---|
| numbering | Dynamic Ascending |
|---|
| sparkName | Sparkline |
|---|
| column | Customer Status,Suspicious Transaction Activity |
|---|
| hidePane | Table header |
|---|
| sort | Last Name ⇧,Transaction amount ⇧ |
|---|
| separator | Point (.) |
|---|
| labels | ‚ |
|---|
| default | Blocked,Yes |
|---|
| isFirstTimeEnter | true |
|---|
| cell-width | 150,150 |
|---|
|
| Table Filter |
|---|
| numbering | Static Ascending |
|---|
| default | Blocked,Yes |
|---|
| cell-width | 150,150 |
|---|
| column | Customer Status,Suspicious Transaction Activity |
|---|
| datepattern | yy-mm-dd |
|---|
| id | 1457698106343_-154178340 | 1612855669084_26563024 |
|---|
| worklog | 365|5|8|y w d h m|y w d h m |
|---|
| isOR | AND |
|---|
| order | 0,1 | separator | Point (.) |
|---|
|
First Name | Last Name | Transaction amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number | ReubenBarnett$12942GuápilesTunisia8McKenzieCleveland$21675SavannahUnited States1PortiaLang$42253Meerut | Côte D'Ivoire (Ivory Coast) | Rejected65 | Moustier-sur-Sambre | Czech Republic | Approved | No |
5EaganMcgee$25303Orangeville | AfghanistanCavaion Veronese | Palestine, State of | Approved | No |
2RahimVelazquez$45406Lac-SerentGeorgiaApproved6RothHull$14257Luziânia | Sao Tome and Principe | Blocked | NoMerksem | Dominica | Approved | Yes | 4 |
JackGriffin$14660GeorgiaBahamasNo4FaithNewton$32496OkigweSri LankaRejectedBasiaRay$26039ValcourtEquatorial GuineaRejectedYes4LeandraDuncan$38033MySwaziland6CameranVelasquez$14475SchiltigheimBangladeshRejectedYes8AmeryPoole$41848ZolderAzerbaijanYes1OwenWelch$27912SpringdaleBeninYes4GermaineHines$34708BellingenAlgeriaApprovedNo6ThaneCortez$33856PenrithTunisiaApprovedYes1SeanDelacruz$42167Vietri di PotenzaLibyaRejectedWillowSkinner$21670Ham-sur-Sambre | Venezuela08 | Bellingen | Algeria | Approved | No |
1CamillaGood$31110Saint-HilarionMalawiRejectedNoYes | 7 | Ingrid | Horne | $365.20 | Crato | Dominica | Approved | Yes | 4 |
ClaireRaymond$12699WiezeWestern SaharaYes9AkeemHolder$13159SuttonSamoaBlockedYes7YuliHubbard$107Hudson Bay | Bolivia | RejectedLuziânia | Sao Tome and Principe | Blocked | No | 4 |
GregorySampson$33991Stroud | Mozambique | BlockedMeerut | Côte D'Ivoire (Ivory Coast) | Rejected | No |
1FreyaOsborn$19886RextonLuxembourgYes5KylanDillard$26470Market DraytonYemenNo3CurranDickson$36020San FranciscoSaint MartinBlockedNo7SylvesterCampos$33844RiparbellaArmeniaBlocked5HadleyGates$363Chelmsford | New Zealand | RejectedSaint-Maur-des-Fossés | Zambia | Approved | Yes |
7WillaStevens$13789GlabaisJapanApprovedNo2KeelieByers$23610Cavaion Veronese | Palestine, State of | Approved | No | 3 | Wieze | Western Sahara | Blocked | Yes | 9 | Cody | Ross | $219.44 | Gent | Austria |
Jordan | Weber | $249.33 | Shepparton | Anguilla9KarlyWalls$20081CharlottetownGuatemalaApprovedYes7OctaviusCervantes$23563Merksem | Dominica | Approved | YesPittsburgh | British Indian Ocean Territory | Rejected | No | 4 |
TyroneAlvarez$30365Thame | Iraq | Blocked | Yes | 5 | Jolene | Howe | $321.67 | Maple Creek | Togo | Blocked | No | 3 | Cody | Ross | $219.44 | Gent | Austria | Blocked | Yes | 6 | Chase | Bryant | $493.65 | Moustier-sur-Sambre | Czech Republic | Approved | No | 9 | Lynn | Cummings | $484.17 | Metairie | Liechtenstein | Approved | No | 3 | Lars | Shaw | $170.60 | Pittsburgh | British Indian Ocean Territory | Rejected | No | 4 | Cassidy | Porter | $142.39 | Saint-Maur-des-Fossés | Zambia | Approved | Yes | 70 | Ham-sur-Sambre | Venezuela | Approved | No | 1 | Willa | Stevens | $137.89 | Glabais | Japan | Approved | No | 2 | Cameran | Velasquez | $144.75 | Schiltigheim | Bangladesh | Rejected | Yes | 8 | Rahim | Velazquez | $454.06 | Lac-Serent | Georgia | Approved | Yes | 6 | Karly | Walls | $200.81 | Charlottetown | Guatemala | Approved | Yes | 7 | Jordan | Weber | $249.33 | Shepparton | Anguilla | Blocked | Yes | 9 | Owen | Welch | $279.12 | Springdale | Benin | Rejected | Yes | 4 |
3 |