Hello,
I have a pivot table with dates in the columns bucket. I know I can group columns into quarters and years, but I am looking to make a third grouping of a specific period, that is, the trailing twelve months ended September 30, 2018. Ideally, My table would have three colums: 2016, 2017, and Trail Twelve Months Ended September 2018.
FYI - I plan to use this with both regular and power pivots.
Thanks!
Bookmarks