How to add a calculation to beast mode that involves uncollapsing columns into rows
I have a Data table with the Actual amounts for Accounts Receivables to which I have appended another table that has the budget amounts on a monthly basis. I created a sumo card to view the data in pivot format . I now need to add a calculation to the sumo card, but the calculation involves data that comes from the same column.
I assumed that I would have to uncollapse this column in MAgic ETL and then add a calculation as a separate column so that I can view it in a sumo card. But this didn't work
I have attached an excel sheet to explain the dataset I have and what I currenrly see in Sumo View, and what I actually want to see.
Can Someone guide me through this? I Know it should be simple but I am clearly missing some logic here.
I will also include a screenshot of what I tried in Magic ETL