I have a set of costs represented in pivot table. I want to simulate "custom local" -- which is ok. BUt how can I get that simulated value to effect the total sum of "variable selling costs"? the qlikview pivot table dismisses any modificaions made using IF function and calculates total sum value the initial input
I am successfully able to estimate/simulate "custom local" by multiplying it with a variable using a if function.