Good day all
I want to Display a Percentage Profit for several vehicles compared to overall Revenue.
e.g.
- Vehicle 1 sum Revenue divided By total Revenue Made = % on Pie chart
- Vehicle 2 sum Revenue divided by total Revenue Made = % on Pie chart
- Vehicle 3 sum Revenue divided by total Revenue Made = % on Pie chart
Also what Formula could i use on this chart to display only current months data.
Hope this makes sense
Thanks in Advance