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
|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|