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 ($).
Date
Votes
2 comments
-
Jet Reports Historic Posts 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. -
Jet Reports Historic Posts That is perfect, thank you!
Please sign in to leave a comment.