My girlfriend needs to produce some kind of report and she has some basic data that looks like this
She needs to work out some averages and the like and i was thinking a pivot table was probably the best way to show the data.
However am i right in thinking that i can only get the pivot to calculate on columns, therefore the only way to get the pivot to look similar would be to have a seperate row for each month for each branch and then putting this new "Month" column in the column section of the pivot?
She needs to work out some averages and the like and i was thinking a pivot table was probably the best way to show the data.
However am i right in thinking that i can only get the pivot to calculate on columns, therefore the only way to get the pivot to look similar would be to have a seperate row for each month for each branch and then putting this new "Month" column in the column section of the pivot?