I need to calculate percentage of each row element, with respect to column total. I did aggregate transformation and found TOTAL of particular column but I am not able to used it derived column transformation to find percentage.

I tried to used Cache Lookup and dataflow parameter but it didn't work.