I want to have a drop down menu with stuff like "View Last Year," "View Last 6 Months" and then filter by each respective category. But I have no idea how to make a chart that dynamic. I've thought about using =filter() or a pivot table, but just wanted some feedback from you guys.
Screenshot 2022-12-19 10.29.19 PM.png
Bookmarks