this is difficult to describe, so read carefully 😊
column A shows revenue [per region] in total
column B shows the same keyfigure as A, but I am using "Calculate Single result as %"
Now I can see the revenue in total and in % [per region]
column C shows my costs in total
column D: formula: C * B
When calculating column D, column B is read. Tecnically column B is a total value, but using "Calculate Single result as %" it shows %. Unfortunately column D takes the total value of column B and not %.
What can I do to read the %-value in my formula instead of the total value?
Any hints are welcome,