Dynamic calculated column/table based on Slicer selection

Hi Community,   I have been raking up my brains over the below use case for a couple of days now and don't seem to find a way out. Appreciate any help,   I am building a report for my quarterly c...