Dynamic fomula for Month, Qtr and YTD

Hi Team,

I want to find spend, save and loss numbers for the names in the drop down by month, quarter, and YTD. It is in a particular format and I am not sure what kind of formula to use in this case.

I have attached the test file for better understanding

Please note Month and Quarter also have drop down and by selecting them the formula should provide the Spend, save and los numbers.

Appreciate your help!

Thanks!

Guru