Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
Attached the sample qvw and excel data which i was working on.
I have 4 dimensions in my Pivot chart and i need to calculate % of each column against its partial Total.
eg: 85/105 i should get 80.00% instead QV result is 20%. I have attached the qvw /excel and error % screenshot. Can any one help on this.
My set analysis is like this.
Sum(Amt)
/
Sum
(
TOTAL (Amt)
)
DATA
BSClass | GSIB | Enrich | Sector | Amt |
Asset | C&B | Yes | banks | 10 |
Asset | C&B | Yes | banks | 20 |
Asset | Other | Yes | banks | 40 |
Asset | Other | Yes | banks | 50 |
Asset | Fross | Yes | banks | 40 |
Asset | Fross | Yes | banks | 50 |
Asset | C&B | Yes | banks | 55 |
Asset | C&B | Yes | Gov | 20 |
Asset | Other | Yes | Gov | 40 |
Asset | Other | Yes | Household | 50 |
Asset | Fross | Yes | Household | 15 |
Asset | Fross | Yes | Household | 40 |
Advance Thanks
Nishant
Attachment is missing ?
Try this for your % expr
= Sum(Amt)/Sum(TOTAL <GSIB> Amt)
Check This
Neville