Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to automatically calculate salaries actually received in financial year?
The following data as an example (excluding the desired result column)
comes from an Access database. I need for excel to calculate what employees actually salary recieved during the financial year of April 1 to 31 March. What I want is to be able to get a user to click a button on Access which will take them to a pivot table which displays what employees actually received each financial year. This pivot table will be linked to a (hidden) excel sheet where the figure has already been calculated. As it will be a hidden sheet, I need for excel to do this automatically but I can't figure out how to do get this figure without manually manipulating the excel sheet cells. I also have two things that need to be looked into ... How do we calculate a total figure if someone received numerous salary increases in the same financial year (see Steve Bilington 1998/1999). Also, what do we do if there has been no salary increase one year (see Steve Billington is missing a figure for the 2002/2003 financial year as he received no increase that financial year. I need for excel to recognise this but calculate a figure for that missing financial year as I still need it to appear in the pivot table. I dunno what to do!!!! HELP!!!!!!!!!!!! K/ FirstName LastName Salary£ FinYear Date Inc DESIRED RESULT Steve Billington 75000 1998/1999 1-Apr-98 0 Steve Billington 100000 1998/1999 1-Jun-98 0 Steve Billington 130000 1998/1999 1-Oct-98 Sum of £ received in 1998/1999 fin yr Steve Billington 132500 1999/2000 1-Oct-99 £ received in fin year Steve Billington 136000 2000/2001 1-Oct-00 £ received in fin year Steve Billington 151000 2001/2002 1-Oct-01 £ received in fin year Steve Billington 160000 2003/2004 1-Oct-03 £ received in fin year & figure for 02/33 Steve Billington 165000 2004/2005 1-Oct-04 £ received in fin year Steve Billington 175000 2005/2006 1-Oct-05 £ received in fin year Bob Anderson 70000 2005/2006 1-Apr-05 £ received in fin year David Downes 100000 2002/2003 1-Oct-02 £ received in fin year David Downes 114500 2003/2004 1-Oct-03 £ received in fin year David Downes 127500 2004/2005 1-Oct-04 £ received in fin year |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to calculate integrals with Excel? | Excel Worksheet Functions | |||
How do I automatically open linked documents in Excel? | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
PivotTables in Excel 2004 calculate incorrect standard deviations | Excel Worksheet Functions | |||
How do I automatically send daily email of updated Excel workbook. | Excel Discussion (Misc queries) |