cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate prior year YTD to compare to current year

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (0)