Filtering and sorting excel columns

Sorting and filtering to capture certain information is possible through creating the Master CSV Report. This can be generated by navigating to Profiles > Children > Top Right Export > Master CSV 

To sort and filter certain information please follow these steps: 

 

1. Click the number 1 in the top row in the Excel spreadsheet - This will highlight all categories. 

Screen_Shot_2017-10-26_at_1.24.56_pm.png

 

2. Click the Sort & Filter Icon > Click Filter - This will give all categories an arrow to sort 

Screen_Shot_2017-10-26_at_1.25.07_pm.png

 

3. Click the arrow which has the category you wish to sort and filter by ascending or descending. 

Screen_Shot_2017-10-26_at_1.25.24_pm.png