Edit: Can I bug you to do a growth percentage calc as well? For example, Dev Qtr 1 divided by Dev Qtr 0. Then Dev Qtr 2 divided by Dev Qtr 1. Set up as the same matrix, but showing the period on period percentage rather than the running totals. That'll cover absolutely everything I need. Not being cheeky, this was part of my original query
I'll have time to look in a few hours, but it looks very promising! Will mark as solution once I have a quick look.
Thanks so much!!
I've managed to figure out a way on my own for the growth percentage part.
I copied your running total formula, and modified with a -1:
RunTot2Prior = CALCULATE( [TotalAmount], FILTER( ALLSELECTED('new Table'[DevQtr]), ISONORAFTER('new Table'[DevQtr], MAX('new Table'[DevQtr])-1, DESC) ) )
Dev% = DIVIDE([RunTot2],[RunTot2Prior])