Forum Discussion
dharbison
Feb 02, 2023Copper Contributor
Cannot group that selection in a pivot table
Hi there. I have a formula auto-calculating the next date to a column on which I have a pivot table. I have verified that the dates are valid based on the calendar and that there are no unallowable...
Riny_van_Eekelen
Feb 02, 2023Platinum Contributor
dharbison For the grouping to work ALL rows must be dates or truly blank. And when you have blanks, the will show up in a group "less than the earliest date in the list". See picture below.
Since you mention that the date column is calculated, I assume you have formula that returns either a date or and empty string (""). An empty string is NOT blank. That's why you see the item with no label and you can not group de dates anymore.
dharbison
Feb 03, 2023Copper Contributor
Thank you. My formula =IF(H3=3,D3+90,IF(H3=6,D3+180,IF(H3=9,D3+270,IF(H3=12,D3+360,""))))
is returning "" . I guess I've never before tried to group a selection with "" in it.
Thanks for your help!