Forum Discussion

SBiebaut86's avatar
SBiebaut86
Copper Contributor
May 07, 2019
Solved

Pivot Table - Date - Group by Month does not work

Dear all, I am working on my departments budget, and wish to show the costs per month. However, invoices are registered across the month (on 02/01/2019, 05/01/2019, 13/01/2019, ...). Now, the aim is...
excel
Wyn Hopkins's avatar
Wyn Hopkins
MVP
May 07, 2019

SBiebaut86 

 

So you have your pivot set like this and then right click on date and you don't get the Group Option?

 

  • SBiebaut86's avatar
    SBiebaut86
    Copper Contributor
    May 07, 2019

    Wyn Hopkins I get the group option, but once I click it, it tells me 'cannot group that selection'

     

     

    • Yvonne1515's avatar
      Yvonne1515
      Copper Contributor
      Aug 17, 2021

      SBiebaut86 I was having the exact same issue and suddenly it started working after I changed my date format to M, so I guess that's the work around.

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      May 07, 2019
      Avoid having anything else in your row labels box except date and then try grouping

Resources