Hi,
I have big tables data with have many dimensions (as Dim1, Dim2, Dim3....) and have many columns of quantity and amount columns.
Format is as below:
| Dim1 | Dim2 | Dim3 | Quantity | Amount |
| Battery | Import | 1001 | 10 | 100 |
| RML | Import | 1001 | 20 | 200 |
| Radio | Import | 1001 | 30 | 300 |
| Battery | Domestic | 1001 | 40 | 333 |
| RML | Domestic | 1001 | 5 | 444 |
| Radio | Domestic | 1001 | 7 | 222 |
| Battery | Import | 1002 | 8 | 111 |
| RML | Import | 1002 | 9 | 654 |
| Radio | Import | 1002 | 11 | 78 |
| Battery | Domestic | 1002 | 10 | 54 |
| RML | Domestic | 1002 | 55 | 32 |
| Radio | Domestic | 1002 | 44 | 45 |
Now I wants to show the data in below mentioned form:
| Dim | Sum of Actual | formula (only for understanding) |
| Battery Quantity | 68 | sum of Qty |
| Battery Quantity (Domestic) | 50 | sum of Qty |
| Battery Quantity (Import) | 18 | sum of Qty |
| RML Quantity | 89 | sum of Qty |
| RML Quantity (Domestic) | 60 | sum of Qty |
| RML Quantity (Import) | 29 | sum of Qty |
| Radio Quantity | 92 | sum of Qty |
| Radio Quantity (Domestic) | 41 | sum of Qty |
| Radio Quantity (Import) | 51 | sum of Qty |
| Battery Rate (Domestic) | 7.74 | Sum of Amount/Sum of Qty |
| Battery Rate (Import) | 11.72 | Sum of Amount/Sum of Qty |
Kindly suggest how to get this format in qlikview.
I cannot use crosstable or any other table formation methods because data is too big. Wanna changes in front end with the help of mapping from excel or through expression.
