In order to allow filtering of data using DataView, please follow the steps below:
- Ensure that the DataView macro and DataViewResults macro have been inserted on your page
- Insert the DataView Filter macro on to your page
- Select the filter required from the dropdown box
This allows you to select any option that appears in the selected column in the spreadsheet
As soon as you click on the filter option you want, the data results should automatically change to reflect the filter option you have chosen (in this example, showing only results that have 'High' in the 'Performance' column).