
1. Re: How to write calculation for 2018 and QoQ YoY
Shinichiro Murakami Jun 20, 2018 5:13 PM (in response to Helen Wang)1 of 1 people found this helpfulHI Helen
Quit a bit difficult to guide without data, but add Attr + brackets " attr() "to aggregate dimension.
Thanks,
Shin

2. Re: How to write calculation for 2018 and QoQ YoY
Helen Wang Jun 20, 2018 5:15 PM (in response to Shinichiro Murakami)Thank you so much .
May Iask why attr() may help?

3. Re: How to write calculation for 2018 and QoQ YoY
Shinichiro Murakami Jun 20, 2018 5:17 PM (in response to Helen Wang)1 of 1 people found this helpfulis arregated value and need to align.
Could you please marl my answer as correct to close the thread. Not from inbox view, but from original post.
Thanks,
Shin

4. Re: How to write calculation for 2018 and QoQ YoY
Helen Wang Jun 20, 2018 5:24 PM (in response to Shinichiro Murakami)1 of 1 people found this helpfulCould you please tell me how to make attr() work with '2018;? It is showing error.
It says cannot compare interger and string level

5. Re: How to write calculation for 2018 and QoQ YoY
Shinichiro Murakami Jun 20, 2018 5:32 PM (in response to Helen Wang)1 of 1 people found this helpfuladd 'str' ' or '2018' ==> 2018 and add attr to quarter , too.
Please read error message,
To be honest this is very stressful to me to guide you without data.
Shin

6. Re: How to write calculation for 2018 and QoQ YoY
Hari Ankem Jun 20, 2018 7:53 PM (in response to Helen Wang)
Q217 POS YoY.twbx 1.2 MB


7. Re: How to write calculation for 2018 and QoQ YoY
Helen Wang Jun 21, 2018 10:07 AM (in response to Hari Ankem)Hari thank you so much!
I am wondering, do I have to show $Net POS Actual as well to calculate the $POS QoQ so that I can extract Q2 2017 QoQ?
Is there anyway I can just show POS 2017 QoQ?

8. Re: How to write calculation for 2018 and QoQ YoY
Hari Ankem Jun 21, 2018 10:51 AM (in response to Helen Wang)You can try removing all the other measures and see that your calculations do not get affected. As long as they do not, you can remove it.
If, however, the calculations do get affected, you can do one of the following:
1. Hide the measure values; or
2. Move the measure value from the rows to the Detail marks.
In the below image, I have removed all the other measures, and displaying only the 2017 QoQ. I have subsequently filtered out all the null values. The updated workbook is attached.

Q217 POS YoY.twbx 1.2 MB


9. Re: How to write calculation for 2018 and QoQ YoY
Helen Wang Jun 21, 2018 2:10 PM (in response to Shinichiro Murakami)Thank you for your help!

10. Re: How to write calculation for 2018 and QoQ YoY
Helen Wang Jun 21, 2018 2:10 PM (in response to Hari Ankem)Thank you so much for your help Hari!

11. Re: How to write calculation for 2018 and QoQ YoY
Hari Ankem Jun 21, 2018 2:13 PM (in response to Helen Wang)1 of 1 people found this helpfulYou are welcome.

12. Re: How to write calculation for 2018 and QoQ YoY
Helen Wang Jun 21, 2018 3:32 PM (in response to Hari Ankem)Hi Hari,
Hope all is well.
If you have time, could you please help me take a look at this question?
How to automate my calculation formula by indexing to avoid hard coding every quarter
Thanks!
Helen

13. Re: How to write calculation for 2018 and QoQ YoY
Helen Wang Jun 21, 2018 3:40 PM (in response to Hari Ankem)Hi Hari!!
If you have time, could you please help me take a look at this question as well?
Thank you so much for your help!!
How to pull data from 'Current Quarter 1' (which is previous quarter)
I hope you have a great day!
Helen