Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Calculations
Hi All,
I have created a pivot table showing the following; Code Customer 03/11/07 10/11/07 17/11/2007 Average Inv Total ambak The Shop 189.25 164.18 192.15 181.86 The aim of my pivot table is to check for invoicing descrepencies so i would like to have a calculation that will get the 17/11/2007 invoice amount and - it from the average invoice amount. Im aware that i could show the invoice totals differnece by using the show data as % difference from previous, but if that invoice was wrong before then i think it will make my figures unreliable? Thanks in advance for any help given |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Calculations | Excel Worksheet Functions | |||
Pivot Table Calculations | Excel Discussion (Misc queries) | |||
Pivot table for calculations | Excel Discussion (Misc queries) | |||
Calculations in pivot table | Excel Worksheet Functions | |||
Pivot Table calculations | Excel Discussion (Misc queries) |