Dates grouped by 1/4 and weekly

Hi All, I have a massive payroll sheet that has bi-weekly amounts for all gross pay, deductions, etc. The sheets are setup showing biweekly dates (every 2 weeks). However, to calculate my WSIB payments, i need to group a particular pivot table to show the 1st quarter. Sometime since one of the last Office updates, this no longer works.

When I look at my filters, I have 2 fields, Date (mm/dd/yyyy) and Year (yyyy) taken from the spreadsheet that has the last 10 years of individual payroll information.

My date field USED to show grouped dates, but now it only shows them as the individual dates.
My system is setup to show mm/dd/yyyy and this is how the data is entered.

Instead of me having to check off the individual weeks for this pivot table, how can I force excel to group the data for THIS pivot only?

The spreadsheet is full of confidential data, and is very complicated set of pivots, so sending or posting a copy wont be possible. (I know this will make things harder to help me)

How can we get this specific pivot to group the dates by quarter and not affect any of the other pivots that MUST stay ungrouped?

Issue is, if I go to my pivot table, and I add the DATE field to the Pivot, and I R-Click and select GROUP, then every pivot table in the ENTIRE worksheet goes to grouped dates, and I lose my bi-weekly pivot table reports.

It may be that "unsharing" the pivot table data cache will do what you want.
https://support.microsoft.com/en-us/...7-9e3a4a05542b

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.