Hi guys,
Please see the attached, I am struggling to do a few things.
One is that for month 201604 i would like it to count the number of working days in that month, I have put workingdays as 1 if it is a working day.
I would also like to compare with the same month but last year, but struggling to figure it out, not sure how i would pivot it as i would like it to be
201604 201504
I also note I spelt 'SUM' wrong, but it didn't work even when it was correct to be fair.
Your help would be much appreciated,
James.
