Hi All,
A question mostly PowerPivot related for data that are exported from Access:
i would like to have a pivot table showing payroll.
Raw data look like this:
Following some research, i created a Date table on PowerPivot that i linked with my table above.
My aim was to create a pivot table that shows all months, not just the ones where there is relevant context.
It didn't work (even though i suspect that's an easy fix)
that would be my first question then!
The second question, is there a way to fill in all gaps with the immediate previous salary change till a new change occurs?
i.e. repeat Andy's 25000 from Oct-2011 till Apr-2015 (green rectangular) and so on?
That way, i'll have a table with the entire payroll per month.
Many thanks in advance