I'm having trouble making a pivot table that will show me the running sum of our sales broken out over order days prior to opening, next to the season goal amount, and then track the running sales to goal. Here's what I'm trying to see:
Order days prior to Open Total Paid/Reserved Value Goal % to Goal
-4 250,000 1,000,000 25%
-3 500,000 1,000,000 50%
-2 750,000 1,000,000 75%
-1 1,000,000 1,000,000 100%
Has anyone build anything like this? What is the trick to getting the goal to stay static (based on budget amounts for all the performances in one season)?
I've tried suggestions I've found in other posts (like this one), but the goal amounts shift over each day prior to opening.
Any help is always greatly appreciated.
Thanks,
Michael
The 'Goal' amount could be a hard-coded 'Formula' that you just type a number for. You can create a 'Formula' and set it to '$1,000,000', and boom, you're done. The Total Paid/Reserved would update, and you could pull that into relationship with the $1,000,000 as you need to. Once you set the formula to a static number, it will stay that way for each Row/Value intersection.