| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Totals
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? -- ajames ------------------------------------------------------------------------ ajames's Profile: http://www.excelforum.com/member.php...o&userid=31502 View this thread: http://www.excelforum.com/showthread...hreadid=514333 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totals of calculated field in pivot table give incorrect results | Excel Worksheet Functions | |||
| Incorrect totals in Pivot Table | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Pivot Table Totals | New Users to Excel | |||
| How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
Threaded Mode
