Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be change the order of your dimensions or use a straight table instead
Why don't you use CrossTable load in the script to transform your data in that case?