@PaulHallam I had made the calculation for #1, but not sure about others, could you please put all this in excel sheet sample data dn the calculations, it will help to get this going otehrwise there will be lot of back and forth.
Did I answer your question? Mark my post as a solution.
Proud to be a Datanaut! Appreciate your Kudos Feel free to email me with any of your BI needs.