Group date row by month and year?

Post Reply
User avatar
wilbertnl
Posts: 2
Joined: Fri Jan 30, 2009 2:01 am
Location: Tulsa, OK

Group date row by month and year?

Post by wilbertnl »

I import a csv file and I create a pivot table. In the pivot table I would like the date to be grouped by month and year.
In LibreOffice when I select grouping, I get a dialog that lets me select the groupings like the following attachment:
Screenshot from 2018-01-06 08-12-33.png
In Planmaker, however, I won't get a similar selection:
Screenshot from 2018-01-06 08-15-27.png
How would I group dates by month and year in Planmaker?

Thank you very much
sven-l
SoftMaker Team
SoftMaker Team
Posts: 6251
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Group date row by month and year?

Post by sven-l »

Could you please attach the .csv file here or send it to forum(at)softmaker.com? Thank you!
Sven Leßmann
SoftMaker Software GmbH
qufjsltoww
Posts: 2
Joined: Mon May 06, 2019 8:41 pm

Re: Group date row by month and year?

Post by qufjsltoww »

@wilbertnl did you find a solution? I also am unable to find a way to group by month in Row Labels using a pivot table like I can in other spreadsheet apps.
qufjsltoww
Posts: 2
Joined: Mon May 06, 2019 8:41 pm

Re: Group date row by month and year?

Post by qufjsltoww »

@sven-l Any updates you can share? Thanks
martin-k
SoftMaker Team
SoftMaker Team
Posts: 3103
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany
Contact:

Re: Group date row by month and year?

Post by martin-k »

Pivot tables currently do not support date grouping. There is already a feature request with the developers, but no timeline yet when this will be implemented.
Martin Kotulla
SoftMaker Software GmbH
Post Reply

Return to “PlanMaker 2018 for Windows”