I have zero experience with pivot tables so this is a learning opportunity. Thanks Olly. However, I can't get it to sort monthly. When I expand the year columns I have individual days as opposed to monthly totals. I see the "group" option but it is asking me to enter values. Do I have to manually enter the datevalue for each date range? I assume there is a much easier alternative staring me in the face.