Pivot table unable to group dates

amke

New Member
Joined
Jul 6, 2010
Messages
3
If I choose the source data for my pivot table as colums (providing for continous updating) I cannot group my dates per year/month.
Because Excel says I have zero empty rows for date (all rows do contain dates, so zero are left blank)

If I select the exact cells containing the data I can overcome this grouping issue BUT than I cannot update my pivot table without reselecting the source.

Is tere a way I can make my grouping work, without losing the ability to update my pivot table?

Thanks a lot for your reaction,
Anne-Marie
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,819
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Use a dynamic data source. See Debra Dalgleish's tip here.
 

amke

New Member
Joined
Jul 6, 2010
Messages
3
Thanks,

Now I know at what direction I need to point my nose :)
I try to figure it out !

Anne-Marie
 

Watch MrExcel Video

Forum statistics

Threads
1,118,848
Messages
5,574,629
Members
412,607
Latest member
caner
Top