Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
Please refer below the data which is in Qlikview need to show the Pivot table in multiple dimension as mentioned below
Entity | Account Name | Type | Date | Amount1 | Amount2 | Amount3 | Amount4 |
A | A1 | I-1 | 01-10-2021 | 500 | |||
A | A1 | I-2 | 01-10-2021 | 1500 | |||
A | A1 | D-1 | 01-10-2021 | 200 | |||
A | A1 | D-2 | 01-10-2021 | 300 | |||
A | A1 | ST | 01-10-2021 | 2000 | |||
A | A1 | LT | 01-10-2021 | 2500 | |||
A | A1 | Oth | 01-10-2021 | 300 | |||
A | A1 | I-1 | 01-10-2021 | 500 | |||
A | A1 | I-2 | 01-10-2021 | 1500 | |||
A | A1 | D-1 | 01-10-2021 | 200 | |||
A | A1 | D-2 | 01-10-2021 | 300 | |||
A | A1 | ST | 01-10-2021 | 2000 | |||
A | A1 | LT | 01-10-2021 | 2500 | |||
A | A1 | Oth | 01-10-2021 | 300 | |||
A | A2 | I-1 | 01-10-2021 | 100 | |||
A | A2 | I-2 | 01-10-2021 | 1700 | |||
A | A2 | D-1 | 01-10-2021 | 250 | |||
A | A2 | D-2 | 01-10-2021 | 350 | |||
A | A2 | ST | 01-10-2021 | 250 | |||
A | A2 | LT | 01-10-2021 | 1640 | |||
A | A2 | Oth | 01-10-2021 | 500 | |||
A | A2 | I-1 | 01-10-2021 | 1500 | |||
A | A2 | I-2 | 01-10-2021 | 300 | |||
A | A2 | D-1 | 01-10-2021 | 450 | |||
A | A2 | D-2 | 01-10-2021 | 4640 | |||
A | A2 | ST | 01-10-2021 | 5460 | |||
A | A2 | LT | 01-10-2021 | 5640 | |||
A | A2 | Oth | 01-10-2021 | 6580 | |||
B | B1 | I-1 | 01-10-2021 | 500 | |||
B | B1 | I-2 | 01-10-2021 | 1500 | |||
B | B1 | D-1 | 01-10-2021 | 200 | |||
B | B1 | D-2 | 01-10-2021 | 300 | |||
B | B1 | ST | 01-10-2021 | 2000 | |||
B | B1 | LT | 01-10-2021 | 2500 | |||
B | B1 | Oth | 01-10-2021 | 300 | |||
B | B1 | I-1 | 01-10-2021 | 500 | |||
B | B1 | I-2 | 01-10-2021 | 1500 | |||
B | B1 | D-1 | 01-10-2021 | 200 | |||
B | B1 | D-2 | 01-10-2021 | 300 | |||
B | B1 | ST | 01-10-2021 | 2000 | |||
B | B1 | LT | 01-10-2021 | 2500 | |||
B | B1 | Oth | 01-10-2021 | 300 | |||
B | B2 | I-1 | 01-10-2021 | 100 | |||
B | B2 | I-2 | 01-10-2021 | 1700 | |||
B | B2 | D-1 | 01-10-2021 | 250 | |||
B | B2 | D-2 | 01-10-2021 | 350 | |||
B | B2 | ST | 01-10-2021 | 250 | |||
B | B2 | LT | 01-10-2021 | 1640 | |||
B | B2 | Oth | 01-10-2021 | 500 | |||
B | B2 | I-1 | 01-10-2021 | 1500 | |||
B | B2 | I-2 | 01-10-2021 | 300 | |||
B | B2 | D-1 | 01-10-2021 | 450 | |||
B | B2 | D-2 | 01-10-2021 | 4640 | |||
B | B2 | ST | 01-10-2021 | 5460 | |||
B | B2 | LT | 01-10-2021 | 5640 | |||
B | B2 | Oth | 01-10-2021 | 6580 |
Also attached in Excel as well
Thanks and Regards,
Sakthivel.S