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:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,570
Super User 2024 Season 2
#2
Martin Dráb
228,683
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
