Skip to Content
author's profile photo Former Member
Former Member

How to calculate prior year YTD to compare to current year

I have a count of quotes for 2016 and 2017. I have figured out how to calculate the runningsum of each and have charted it by week.

The ask is to figure out a way to do the following:

1. Chart the 2017 and 2016 values so that when the report is refreshed it shows what the 2016 quotes were YTD, 2017 is the easy part.

2. Calculate the percentage difference between the two.

Below is a picture showing the data in the table and a chart. But each is showing the entire 2016 year.

vmb.png (23.9 kB)
Add comment
10|10000 characters needed characters exceeded

0 Answers