Hari! You are a genius! Thank you!
Did you do this by coding or just add the calculation?
I have also noted a question:
When I want to add QoQ for Profit and Sales seperately, it seems that I need to name the QoQ for Profit : "QoQ for Profit" and the QoQ for Sales " QoQ for sales" .
Can I expect that I simply code for one QoQ and it is used for everything?
Thanks and best regards,
1 of 1 people found this helpful
I duplicated the earlier calculated field, and changed the 1 to 2. Did not code it explicitly.
You cannot have a single QoQ and use it for everything. Profit and Sales are different measures, and when you do table calculations, you are doing it for each of the measures separately.
Alternatively, you can have a single QoQ, but will need a parameter to identify whether the computation should be based on Profit or Sales.