This content has been marked as final.
Show 5 replies
-
1. Re: Compare data from prior quarter under the same timeline
Zhouyi ZhangJun 6, 2017 12:21 AM (in response to Loretta Xia)
Hi, Loretta
can you provide a sample workbook?
ZZ
-
2. Re: Compare data from prior quarter under the same timeline
Loretta Xia Jun 6, 2017 2:18 AM (in response to Zhouyi Zhang)Hi zz,
Thanks for your reply!!
Here you go with some simple data..
lmk if there's anything you need.
Loretta
-
lastQuarterSales.twbx 12.6 KB
-
-
3. Re: Compare data from prior quarter under the same timeline
Zhouyi ZhangJun 6, 2017 4:45 AM (in response to Loretta Xia)
Hi, Loretta
Is this what you are after?
I attached the workbook for your reference. please let me know if you have question
ZZ
-
lastQuarterSales.twbx 17.3 KB
-
-
4. Re: Compare data from prior quarter under the same timeline
Loretta Xia Jun 6, 2017 7:19 PM (in response to Zhouyi Zhang)Hi zz,
Thank you so much for the great idea!
I made a little change of your code there.. the month doesn't fall in the right place in your code.
Anyways, THANK U!!!!
Loretta
-
lastQuarterSales (1).twbx 16.9 KB
-
-
5. Re: Compare data from prior quarter under the same timeline
Zhouyi ZhangJun 6, 2017 7:33 PM (in response to Loretta Xia)
no worries. glad it helps you figure out your case.
ZZ