I have three columns, revenue, expenses and percentage. Percentage is just the individual expense divided by revenue. Is there any way to change the expenses column numbers so that the total percentage at the bottom which is currently 19%, will change to 100%, so I want the numbers in expenses column to change so that the total percentage will become 100%. Is there a way to do this by formula or what if analysis.
Revenue | Expenses | Percentage | |
3051 | 109 | 4% | |
1607 | 606 | 38% | |
4910 | 111 | 2% | |
3628 | 636 | 18% | |
1630 | 884 | 54% | |
1009 | 444 | 44% | |
3514 | 104 | 3% | |
1354 | 869 | 64% | |
1912 | 869 | 45% | |
2733 | 864 | 32% | |
3861 | 750 | 19% | |
3421 | 732 | 21% | |
1613 | 460 | 29% | |
3920 | 291 | 7% | |
2423 | 596 | 25% | |
4262 | 783 | 18% | |
4473 | 331 | 7% | |
Total | 49321 | 9439 | 19% |