This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Yes both are doable, in fact there are lots of ways you could go about this. My method based on your current table structure would be to transpose and use a multirow formula grouped by your account.
There's two questions from your two messages, so I've included both in the example attached:
There's a container for each question. Note I've assumed variance as ([Value]/[Row-1:Value])-1, but you can just do a simple ([Value]-[Row-1:Value]) if that's what you're after
Question 2 has an extra filter after the transpose; this is where you choose the months you'd want to compare (as opposed to Q1 which always looks back 1 month). Right now, Q2 this is set to look back 2 months within that filter, but you could use an action tool with some on the filter if you wanted a user to click two boxes to choose the months to compare. I don't know if you're new to those tools; there's some useful info here https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Action/ta-p/35500 , or obviously you can simply update the filter yourself if that's easier.
For future reference, another option for future reference would be to turn your headers into actual dates (using 'datetimeparse'), and use date formulas from there.
Let me know if this works for you, or needs more explaining. Hope it helps!