AdamPriest
New Member
- Joined
- Oct 28, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi,
I'm trying to forecast daily spend for an advertising campaign and would like to know if it's possible to 'pivot' the data based off a %.
I have four different budgets amounts to share between two products and would like to pivot my data based off different % splits between the two i.e. what would my projected sales be if put 40% of the budget into product A and 60% into Product B. Ideally I'd like to be able to update these %'s on the go and have sheet recalculate as i do so.
My data is based off budget amounts of;
Thanks,
Adam
I'm trying to forecast daily spend for an advertising campaign and would like to know if it's possible to 'pivot' the data based off a %.
I have four different budgets amounts to share between two products and would like to pivot my data based off different % splits between the two i.e. what would my projected sales be if put 40% of the budget into product A and 60% into Product B. Ideally I'd like to be able to update these %'s on the go and have sheet recalculate as i do so.
My data is based off budget amounts of;
- £250
- £500
- £750
- £1000
- 92 Day campaign
- The daily spend figures are currently calculated off a 50% split, which I've simply done by dividing the budget amount by 92 and then 2 i.e =A6/92/2
Thanks,
Adam