Forum

Notifications
Clear all

Missing Dialogue Box When Trying to Group Dates in a Pivot Table

2 Posts
2 Users
0 Reactions
184 Views
(@jewels33)
Posts: 1
New Member
Topic starter
 

Hello, I stumbled upon your answer here when searching for why I am not getting a dialogue box while grouping dates in my pivot table. The dates should be formatted correctly as dates (00/00/0000). Whenever I click "group" it will insert a group header "Group1" in my pivot table but no dialogue box appears. What am I doing incorrectly here? Thank you in advance. 

 
Posted : 24/08/2022 11:28 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Julie,

It sounds like you're selecting multiple cells containing the dates before you right-click. You only need to select one date cell, then right-click > group.

Mynda

 
Posted : 25/08/2022 6:02 am
Share: