<< Go Back Download Ruleset Edit Ruleset

Demo for Column Filtering

A basic ruleset for column filtering, i.e. each selected column has its own separate search filter.
Sample Tables
AnnoRegioneEtàGenereTotale
2012Abruzzo15M5960
2012Abruzzo16M6157
2012Abruzzo17M6287
2012Abruzzo15F5845
2012Abruzzo16F5772
2012Abruzzo17F6016
2012Basilicata15M2968
2012Basilicata16M3002
2012Basilicata17M3079
2012Basilicata15F2776
2012Basilicata16F2843
2012Basilicata17F2986
2012Calabria15M10496
2012Calabria16M10595
2012Calabria17M11152
2012Calabria15F9813
2012Calabria16F10286
2012Calabria17F10446
2012Campania15M34444
2012Campania16M34493
2012Campania17M35492
2012Campania15F32606
2012Campania16F33416
2012Campania17F33918
2012Emilia Romagna15M18112
2012Emilia Romagna16M17915
2012Emilia Romagna17M18050
2012Emilia Romagna15F17080
2012Emilia Romagna16F16623
2012Emilia Romagna17F16838
2012Friuli Venezia Giulia15M5157
2012Friuli Venezia Giulia16M4971
2012Friuli Venezia Giulia17M4946
2012Friuli Venezia Giulia15F4815
2012Friuli Venezia Giulia16F4657
2012Friuli Venezia Giulia17F4643
2012Lazio15M25412
2012Lazio16M25755
2012Lazio17M26042
2012Lazio15F23961
2012Lazio16F24031
2012Lazio17F24519
2012Liguria15M6443
2012Liguria16M6180
2012Liguria17M6257
2012Liguria15F5950
2012Liguria16F5901
2012Liguria17F5938
2012Lombardia15M44412
2012Lombardia16M43613
2012Lombardia17M43667
2012Lombardia15F41727
2012Lombardia16F40945
2012Lombardia17F40850
2012Marche15M6953
2012Marche16M7044
2012Marche17M6933
2012Marche15F6477
2012Marche16F6579
2012Marche17F6493
2012Molise15M1479
2012Molise16M1494
2012Molise17M1624
2012Molise15F1443
2012Molise16F1526
2012Molise17F1509
2012Piemonte15M18743
2012Piemonte16M18613
2012Piemonte17M18694
2012Piemonte15F17550
2012Piemonte16F17524
2012Piemonte17F17720
2012Puglia15M22115
2012Puglia16M22321
2012Puglia17M22918
2012Puglia15F20967
2012Puglia16F21082
2012Puglia17F21589
2012Sardegna15M7388
2012Sardegna16M7603
2012Sardegna17M7736
2012Sardegna15F6652
2012Sardegna16F6895
2012Sardegna17F7159
2012Sicilia15M27731
2012Sicilia16M28168
2012Sicilia17M29192
2012Sicilia15F26335
2012Sicilia16F26726
2012Sicilia17F27640
2012Toscana15M15167
2012Toscana16M15120
2012Toscana17M15111
2012Toscana15F14386
2012Toscana16F14156
2012Toscana17F14393
2012Umbria15M3798
2012Umbria16M3802
2012Umbria17M3772
2012Umbria15F3576
2012Umbria16F3609
2012Umbria17F3599
2012Valle d'Aosta15M594
2012Valle d'Aosta16M555
2012Valle d'Aosta17M538
2012Valle d'Aosta15F554
2012Valle d'Aosta16F508
2012Valle d'Aosta17F513
2012Veneto15M22898
2012Veneto16M22592
2012Veneto17M22553
2012Veneto15F21508
2012Veneto16F20814
2012Veneto17F21032
2012PA Bolzano15M2893
2012PA Bolzano16M2870
2012PA Bolzano17M2870
2012PA Bolzano15F2810
2012PA Bolzano16F2590
2012PA Bolzano17F2727
2012PA Trento15M2742
2012PA Trento16M2660
2012PA Trento17M2686
2012PA Trento15F2606
2012PA Trento16F2554
2012PA Trento17F2526
This ruleset demonstrates the typical scenario where we will add an empty row right below the top header, just to put the filters there. The empty row can be added in the source data as well. Also notice there are various types of filters. For instance, if your type the values of the column. The location filter will find all locations that start with the given search phrase while the athlete filter will search for all rows that contain the key phrase anywhere in the athlete's name (start to end of the string).