Screen Shot 2016-08-11 at 1.59.32 PM.png
I have a range of data that shows the number of certain types of vehicles sold by color, pear year, per week. Column A is the year, Column B is the week, Row 1 is the type of vehicle, Row 2 is the color of the vehicle.
I need to be able to filter the table to display:
-all of a certain week
-all of a certain year
-all of a certain vehicle
-all of a certain color
-a combination of the above
For example I'd like to be able to filter it down so I can view only the red vehicles sold in week 2 of each year, or the trucks sold per week in 2016. Ideally there would be some form of drop down list.
Is there any way of doing this?
Bookmarks