As shown in the table below, I have pre-calculated (%) values for C1 and C2 in the measure C3. Is there a way in Qlik sense where I can make a pivot table where I can show these pre-calculated values while rolling-up/drilling-down between C1 and C2 using C3 as the measure?
C1 | C2 | C3 |
V1 | | 45% |
| a | 10% |
| b | 20% |
| c | 30% |
| d | 40% |
V2 | | 42% |
| a | 10% |
| b | 20% |
| d | 40% |