A
ajames
I have a pivot table that analyses data from three different
spreadsheets (including the one it is currently in). It contains
revenue per sector and weighted revene per sector. The third column
contains the weighted data as a percentage of the actual revenue and
calculates and updates automatically for each sector. HOWEVER, the
total figure at the end of the column does not divide one by the other,
it adds up all the percentage figures above - so is obviously incorrect.
Does anyone know how to resolve this?
spreadsheets (including the one it is currently in). It contains
revenue per sector and weighted revene per sector. The third column
contains the weighted data as a percentage of the actual revenue and
calculates and updates automatically for each sector. HOWEVER, the
total figure at the end of the column does not divide one by the other,
it adds up all the percentage figures above - so is obviously incorrect.
Does anyone know how to resolve this?