I'm brand new to google sheets. But how would I make a chart dynamic to this table here? I want to include a dropdown menu that has stuff like: " Last Year","Last 6 Months" and then filter it by category. I was thinking of maybe using =filter(), but wanted to get some input
I tried using =filter(), using a pivot table, but I'm just lost.