I finally managed to create my first 'complicated' formula - although it was based on one given to me in this forum. It's a small victory for me.
Problem is I still am not quite where i want to be with my data and pivottables.
I have this formula working <=GETPIVOTDATA([JobCostingcopy]Sheet1!$D$4," apr brian")>
First off - the formula seems to work regardless of the abs ref used - I've used $A$4 thru $D$4 and the formula still works ???? would someone try and explain this to me?
Back to my question. I have redone my DB to include a month column and a day column instead of only a date column. My aim is to extract 'pay period' data per employee. Being able to get the monthly totals is working with the formula I have. The problem is my pay period is not based on straight 'monthly' data.
My pay period runs from the 16th to the 15th, with a draw based on hours from 16th to end of month payable the 5th and payroll check based on the 16th to the 15th (less draws) payable the 20th.
As I enter my DB data, the employee pivottable extracts the data and the employee time sheet will similarly extract from the pivottable but with the details/formulas of the 'pay period' ($/hr; hrs worked; draws; totals; etc).
This is gonna be a huge help to me - any clues for me?
tfyh
Buz
Problem is I still am not quite where i want to be with my data and pivottables.
I have this formula working <=GETPIVOTDATA([JobCostingcopy]Sheet1!$D$4," apr brian")>
First off - the formula seems to work regardless of the abs ref used - I've used $A$4 thru $D$4 and the formula still works ???? would someone try and explain this to me?
Back to my question. I have redone my DB to include a month column and a day column instead of only a date column. My aim is to extract 'pay period' data per employee. Being able to get the monthly totals is working with the formula I have. The problem is my pay period is not based on straight 'monthly' data.
My pay period runs from the 16th to the 15th, with a draw based on hours from 16th to end of month payable the 5th and payroll check based on the 16th to the 15th (less draws) payable the 20th.
As I enter my DB data, the employee pivottable extracts the data and the employee time sheet will similarly extract from the pivottable but with the details/formulas of the 'pay period' ($/hr; hrs worked; draws; totals; etc).
This is gonna be a huge help to me - any clues for me?
tfyh
Buz