Is it possible to limit the date range on a pivot graph?
I have a pivot graph that I'm filtering by customer to show sales per month. I have 'show items with no data' selected in field settings for date, because I need to see all the previous months in the graph, whether or not sales were made in that month.
My only issue now is, is that it shows all the months of the year, so it looks like sales have flatlined at the end of the graph, when really I just don't have that data included yet.
Is there any way to force the pivot graph to end at February 2026 rather than December 2026? Or is it a compromise I have to make to have 'show items with no data' selected?
Maybe I could make a new column for mmm yyyy, but then how can I ensure it's in order? (And if possible, I'd also like it to look more "chunked" into years and months, rather than just Jan 26, Feb 26, etc.)
[link] [comments]
Want to read more?
Check out the full article on the original site