I am trying to set up a headcount change report. I've listed the employee and then the different quarters and the report shows a 1 when the empoyee was there, blank if not. I would like to calculate the change between the quarters (columns) within the pivot but can't figure out how, casue the quarters are from the same field.
see example attached
thanks for any ideas.
Bookmarks