-
1. Re: How to calculate Last Year-1 Quarter on Quarter
Hari Ankem Jun 19, 2018 2:28 PM (in response to Helen Wang)1 of 1 people found this helpful -
2. Re: How to calculate Last Year-1 Quarter on Quarter
Helen Wang Jun 19, 2018 2:32 PM (in response to Hari Ankem)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,
Helen Wang
-
3. Re: How to calculate Last Year-1 Quarter on Quarter
Hari Ankem Jun 19, 2018 3:12 PM (in response to Helen Wang)1 of 1 people found this helpfulI 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.