Pivot Table Help

[RonaldoNas]

I have my pivot table and have total sum of Billable hours for the entire time frame. Can I see just a specific timeframes billable hours in another column? How do I do this?

[#2]

I want to see total hours which I have and add another column that is just current month hours

[#3]

@RonaldoNas Add the date to the Column area of the pivot table and group by month (if not done automatically). That should give you a table with hours for every month with a grand total for the year-to-date.

[#4]

It won’t let me group by. I was trying this

[#5]

@RonaldoNas Are you sure the "dates" are real dates? What do you get when you enter the ISNUMBER function in an empty cell and reference a date?