quarterly snapshot

Options
SarahE
SarahE Member, ALL USERS, Partner, Employee, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

numbers will be uploaded quarterly but in YTD figure, I need to plot the quarterly numbers.

 

Q1 YTD will be imported in Q1 and I need to save it in my Q1 column

Q2 YTD will be imported in Q2 containing both Q1 and Q2 numbers, I need to retain the Q1 above and get the number/result for Q2. By this time, columns for Q1 and Q2 will have values.

then Q3 and then Q4..so on..

 

I only thought of copying the line item (YTD) to another line item (snapshot), I think there would be a better solution on this one. Thanks!

Tagged:

Categories