RE: How to calculate Year to date (YTD) Growth rate?
Jill King: The following formula would work to do annual YTD cumulations where VALUE2 is the item you want to cumulate and you are using a monthly timescale:
CUMULATE('VALUE2') - OFFSET(CUMULATE('VALUE2'), -MONTH(START()), 0)
I found this in another thread. its helpful and solves my problem.