Profile Function - Pulling apart the components of an aggregated sum
I am trying to pull apart the components of a profile function so I can understand the impact of a certain period.
Example - I have a ratable revenue recognition treatment for my bookings and I would like to understand the impact of Q1's bookings in Q4. By the time we get to Q4 we have now layered on Q2 - Q4.
Is there a way to isolate the impact of Q1 on Q4?
There certainly are ways of doing this by adding lots and lots of rows, but wanted to see if there was a more simple way of isolating