I'm not sure Tableau is suitable for these kind of data transformations. You will need a different tool, like Alteryx. Or maybe Tableau Prep can do it - I haven't used it yet.
It is possible in tableau,Please check the links i shared yesterday.
There is no need of alteryx.
Hope it helps,
Thanks for the solution
While droping the Amount(copy) into the T (text) pane i am getting the amounts added up .
I tried changing it discrete and tried with EDIT IN SELF option but i am getting the Sum([amount(copy)]) in the Text pane.
can u help me with this?
NOTE:The dump i handle has 6000 records i have just gave u some sample rows.
Click on Analysis and uncheck aggregate measures