Ok. I hope i can explain this well.
I need to calculate sales increase for my stall. Here's the example and I just can't figure this out.
I want to work with powerpivot for many reasons.
I need to take last year's sales and add 10% for the GOAL. But here's the problem I also bonus my managers when the TOTAL MONTH is up 10% or more.
So lets assume Feb 1-28 /17 was Wednesday to Tuesday full month. And I want them to increase there sales this year Feb 1 starts on a Thursday.
So in my example last year Feb 1-28 the store did $100,000 so they need to do $110,000 for the month to have a 10% increase.
But the same weekdays add up to $95,000 so I need the store to do 13% more each day to complete the month up 10%.
I've loaded the sales from last year into powerpivot but cant figure out the formula. I've tried using date add
But I need to show each days sales for the month but add 13% so they hit the total.
Thanks
I need to calculate sales increase for my stall. Here's the example and I just can't figure this out.
I want to work with powerpivot for many reasons.
I need to take last year's sales and add 10% for the GOAL. But here's the problem I also bonus my managers when the TOTAL MONTH is up 10% or more.
So lets assume Feb 1-28 /17 was Wednesday to Tuesday full month. And I want them to increase there sales this year Feb 1 starts on a Thursday.
So in my example last year Feb 1-28 the store did $100,000 so they need to do $110,000 for the month to have a 10% increase.
But the same weekdays add up to $95,000 so I need the store to do 13% more each day to complete the month up 10%.
I've loaded the sales from last year into powerpivot but cant figure out the formula. I've tried using date add
But I need to show each days sales for the month but add 13% so they hit the total.
Thanks