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
In this iteration, the 'Goal' would have to be the same number across the Rows. You could do fancy things with CASE/WHEN statements (paging @chriswallingford or Heath Wilder ), but this iteration's strength is it simplicity.
Nathanael Pearson Thank you! Your initial suggestion got me started on a solution to my problem. And thank you for paging Chris to take a look as well!
Chris Wallingford Ultimately your suggestion works best for comparing progress compared to last season easily. Thank you for chiming in with your expertise!
Thanks again to you both! Need to remember to reach out to the forums sooner, and save myself some headaches.
This is the way
Heath - bonus points for a perfectly-timed Mandalorian reference!