I have data in an Excel spread-sheet for 2017, 2018 with start and end dates.
The data contains the number of donuts consumed in office by department.
I created a pivot and a column graph for donuts consumed by each department.
I need to split the Pivot and graph by Department and Financial year (Apr 2017 to March 2018, Apr 2018 to March 2019). Can anyone provide suggestions.
Looking for a formulae as the data is large.
Dept Fin Year 2017-18 Fin Year 2018-19
ABC 25 30
BCD 6 15
Tot 31 45
thanks
The data contains the number of donuts consumed in office by department.
I created a pivot and a column graph for donuts consumed by each department.
I need to split the Pivot and graph by Department and Financial year (Apr 2017 to March 2018, Apr 2018 to March 2019). Can anyone provide suggestions.
Looking for a formulae as the data is large.
Dept Fin Year 2017-18 Fin Year 2018-19
ABC 25 30
BCD 6 15
Tot 31 45
thanks
Last edited: