I am trying to calculate product cost which comes from the Revenue * Product Factor, it is not working as expected. Please see the attachment. Please tell me what am I doing wrong here ? is this even the correct approach.
I have 2 different events Revenue and Cost, so Revenue is coming from Revenue Event and Product_Factor is coming from Cost and also I have to use Month Relative range in the expression.
Thank you, I got this working, with AGGR I need to add all the dimensions I have in the chart. With Centre, I have added the Month name as well. it is working fine.
