Great information! Looking forward to part 2. I realized the month on the Report sheet could be populated dynamically using the function: Text($O$2*28,"mmmm"). 😊

Nice for beginners but … if working with this kind of data in the background, you could solve this more efficiently and elegant through PQ and PowerPivot table (two measures and off you go), and it would be more scalable i guess ...

Thanks John. :) :)

For your Month Actual formula, any reason for using "SUMIFS(tblActuals[Order Value],tblActuals[Region],$B6,tblActuals[Month],$O$2)" and copying it down rather than using "SUMIFS(tblActuals[Order Value],tblActuals[Region],$B6:$B11,tblActuals[Month],$O$2)" which would spill the results with fewer formulas? Locked the ranges to be able to copy left and right. Also, rather than having to switch back and forth to reference tables, the table names will be found if you start typing them (good reason to name them "tbl..."!), and once the entire table name is selected, typing "[" will bring up the column names. I find that much easier than flipping back and forth!