Hello,
I am trying to add two columns in my table view as shown below.
For simple addition or subtraction I can add a column but when I try to calculate percentage for each row by total of that column and use that calculated field again I get error in expression.
Can anyone please help me with how can I make it in Qlik Sense?
as shown in below table I am trying to add two more columns by performing calculations on existing data
| A | B | C | D | E |
| Unit Name | Allocation | Revenue | % Revenue of total | Proposed_Allocation |
| Temp 1 | 101 | 12 | C2/(Sum(Revenue)) * 100 | Sum(Allocation)*D2 |
| Temp 2 | 111 | 14 | C3/(Sum(Revenue)) * 100 | Sum(Allocation)*D3 |
| Temp 3 | 121 | 15 | C4/(Sum(Revenue)) * 100 | Sum(Allocation)*D4 |
Thank You
