Skip to Content
0

How to calculate prior year YTD to compare to current year

Feb 14, 2017 at 03:11 PM

18

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers