Forum Discussion
Solved
Pivot table dates with overlapping years
Hoping someone can help with a simple pivot table question - I'm grouping by months to reflect the progress on a project that started in April 2019 and is still ongoing. My challenge is displaying t...
Source data for the pivot table in some cache file on your local drive
Hard to say what's within it. If build PivoTable based on data in your file, dates are shown correctly and you may group/format them as needed.
SergeiBaklan Perfect - i just stumbled across that option as you were replying. thank you !
Sam_Hvitfelt , glad to know it works