I have created a pivot table to calculate our profit & loss report by divisional headings (each department ie contracts, Distribution).
Does anyone know if there is anyway to calculate a certain nominal code as a different percentage for each department ie Contracts 50%, Distribution 15% etc?
