Hi Team,
I need to show multi horizontal dimension in Qlikview pivot table which is shown below and i have the data which is attached.
I need to show high level dimension which i am unable to get it(ie. Interest, Dividends, Gain/Loses/Others
| How to show this | Interest | | Dividends | | Gain/Loses | | Others |
Entity | Account Name | Interest-1 | Interest-2 | | Dividends-1 | Dividends-2 | | Long-Term | Short-Term | | Others |
A | A1 | 1000 | 3000 | | 400 | 600 | | 5000 | 4000 | | 600 |
| A2 | 1600 | 2000 | | 700 | 4990 | | 7280 | 5710 | | 7080 |
A Total | | 2600 | 5000 | | 1100 | 5590 | | 12280 | 9710 | | 7680 |
B | B1 | 1000 | 3000 | | 400 | 600 | | 5000 | 4000 | | 600 |
| B2 | 1600 | 2000 | | 700 | 4990 | | 7280 | 5710 | | 7080 |
B Total | | 2600 | 5000 | | 1100 | 5590 | | 12280 | 9710 | | 7680 |
Grand Total | | 5200 | 10000 | | 2200 | 11180 | | 24560 | 19420 | | 15360 |