How to club data in straight table

[snarrp_Rocky]

From this table(fig1) , I need to calculate the sum of the pnl at each column as per the portfolio wise as shown in the Fig2 pivot table. However I need to show the record at each row wise not clubbed together as in. TRADEDCAPM should have four rows separately for Capital markets, Credit, Equity and SCM.

I have attached my QVW file. Your help is greatly appreciated. Kindly note: I dont want to use IF formula since that might slow down the calculate speed since the size of my QVW is around 200mb.

[sunny_talwar]

May be change the order of your dimensions or use a straight table instead

[snarrp_Rocky]

Thanks Sunny.
I actually wanted to present it like in one column, that is Traded CAPM, Next line Combined trading, Next line Traded .....Lastly Captial Markets, Credit Equity and SCM. All in one column instead of showing them in various columns.....Kindly advise...

[sunny_talwar]

Why don't you use CrossTable load in the script to transform your data in that case?