0

How do I use the date comparison for YoY

Jet Reports Historic Posts

February 15, 2016 02:14

None

Follow

This is for Dynamics NAV in the JDM 2016. I see in the date table there is a date calculation for comparison: Diff. Over Previous Year. How do I actually use this though? If I wanted to apply it to the sales amount measure and have the end user be able to see Year over year amount ($).

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts February 18, 2016 20:57 Official comment

  I asked around and got some information from someone knowledgeable about this. Here is his suggestion:
  
  You need to have a measure selected, such as Sales Amount, and use the “Comparison” level in the “Date Calculation” dimension. Then, and maybe most importantly, you need to filter for the “current” period, and it will calculate the previous period, provide the difference over the previous period, and a percentage.
  
  Here is an example of how this works (click on the image for a larger view):
  
  Hopefully, that is somewhat helpful.
• 0
  
  Jet Reports Historic Posts March 02, 2016 18:02

  That is perfect, thank you!