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
