Pivot Table Help

%3CLINGO-SUB%20id%3D%22lingo-sub-3102940%22%20slang%3D%22en-US%22%3EPivot%20Table%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3102940%22%20slang%3D%22en-US%22%3EI%20have%20my%20pivot%20table%20and%20have%20total%20sum%20of%20Billable%20hours%20for%20the%20entire%20time%20frame.%20Can%20I%20see%20just%20a%20specific%20timeframes%20billable%20hours%20in%20another%20column%3F%20How%20do%20I%20do%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3102940%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3103019%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3103019%22%20slang%3D%22en-US%22%3EI%20want%20to%20see%20total%20hours%20which%20I%20have%20and%20add%20another%20column%20that%20is%20just%20current%20month%20hours%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3103026%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3103026%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1294315%22%20target%3D%22_blank%22%3E%40RonaldoNas%3C%2FA%3E%26nbsp%3BAdd%20the%20date%20to%20the%20Column%20area%20of%20the%20pivot%20table%20and%20group%20by%20month%20(if%20not%20done%20automatically).%20That%20should%20give%20you%20a%20table%20with%20hours%20for%20every%20month%20with%20a%20grand%20total%20for%20the%20year-to-date.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
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?
4 Replies
I want to see total hours which I have and add another column that is just current month hours

@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.

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

@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?