5
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.
Hi olansgz,
Are you using the dynamics365 app?
If so, you can't include a dropdown menu to the chart directly, but you can add more views with different filters.
For date field, you can have the following filter to select as your needs:
The chart is shown based on current view, so you can select the view you need, then click show chart button:
#1
André Arnaud de Cal...
291,419
Super User 2024 Season 2
#2
Martin Dráb
230,492
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
