Pivot table

[james_hanify]

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.

[ramasaisaksoft]

Hi James,

if you share sample source data & expected output then our folks will help to you.

Else it is too tough to find the solution like this image.