Hi experts,
on a dynamic straight table, in the column "Dim3 Value" I obtain the following result with "sum(aggr(Value,Dim1,Dim3))"
| Dim 1 | Dim 2 | Dim 3 | Dim3 Value |
|---|
| | | TOTAL: 140 |
| A | B | E | 0 |
| A | B | F | 0 |
| A | B | G | 0 |
| A | C | E | 0 |
| A | C | F | 0 |
| A | C | G | 0 |
| A | D | E | 84 |
| A | D | F | 15 |
| A | D | G | 41 |
But I would like to obtain this:
| Dim 1 | Dim 2 | Dim 3 | Dim3 Value |
|---|
| | | Total: 140 |
| A | B | E | 84 |
| A | B | F | 15 |
| A | B | G | 41 |
| A | C | E | 84 |
| A | C | F | 15 |
| A | C | G | 41 |
| A | D | E | 84 |
| A | D | F | 15 |
| A | D | G | 41 |
I tried to do this: "sum(aggr(Value,Dim1,Dim3,Dim2))/count (distinct Dim2)", it work only if the DIM1 is only one selected value (in my example the selected value is "A") but if i select more than one DIM1 my qlikview desktop freezes my laptop.
