Dynamic pivot where months change

[Danny-Farrar]

Hi all,

I've got some data and this is currently where I'm getting to. A simple pivot and formula to give me the month by month number of purchases with a total at the end.

Title	Month	Purchased
Cats can fly	Jan	32
Cats can fly	Feb	4
Dogs are dogs	Jan	53
Dogs are dogs	Feb	34
Dogs are dogs	Mar	15
Dogs are dogs	Apr	2

Title	Jan	Feb	Mar	Apr	Total
Cats can fly	32	4	-	-	36
Dogs are dogs	53	34	15	2	104

The issue I have though is that I'll be looking back at the previous 4 months from today, so each real-time month the actual months I'm looking at will change. Is there anything I can do to make this process still dynamically work when the data is coming in for say Aug, Jul, Sep and Oct? I feel like it's a basic question so apologies in advance if I've missed the obvious!

Thanks,

Danny

[JosephSerpis · Accepted solution]

Hi @Danny-Farrar the crosstab can also aggregate a total column and row which was introduced a few versions ago. I mocked up a workflow let me know what you think?

[Danny-Farrar]

I knew dynamic rename was in there somewhere but just couldn't get my head around how to work it - thanks so much @JosephSerpis !