
1. Re: how to find difference betwwen two months
Jamil Ahmed Dec 30, 2016 3:38 AM (in response to vidya k)Use your calculated field in running total, over months

2. Re: how to find difference betwwen two months
Norbert Maijoor Dec 30, 2016 3:23 AM (in response to vidya k)HI Vidya,
What I understand is that you can use "Quick Table Calculation > Difference for your first requirement.
For your second requirement find my approach below as reference and stored in attached workbook version 10.1
a. Sales per month
December: if [Order Date (Months)]=#1122014# then [Sales] END
January: if [Order Date (Months)]=#112015# then [Sales] END
February: if [Order Date (Months)]=#122015# then [Sales] END
etc
b. January  December: sum([January])+sum([December])
c. February  January: sum([January])+sum([Februari])
d. February month: [January  December]+[February  January]
etc

sum of continues months.twbx 401.2 KB


3. Re: how to find difference betwwen two months
vidya k Jan 5, 2017 1:16 AM (in response to Norbert Maijoor)HI Nobert,
Thank for the solution am getting the solution for part a. Here for part B calculation the result is not displaying. Can you help me to solve the [roblem
a) December: if [Order Date (Months)]=#1122014# then [Sales] END
January: if [Order Date (Months)]=#112015# then [Sales] END
February: if [Order Date (Months)]=#122015# then [Sales] END
etc
Thanks,
Vidya

4. Re: how to find difference betwwen two months
Norbert Maijoor Jan 5, 2017 1:31 AM (in response to vidya k)Hi Vidya,
Can you share your workbook?