Display current months; summarize earlier years

Discuss the spreadsheet application

Display current months; summarize earlier years

Postby psdel » Sun Jan 12, 2020 11:53 pm

 Edit: New person with new problem needs new topic; split from Resources for getting better with pivot tables? — MrProgermmer 2020-01-13 06:43 UTC 

This did what I wanted but I want to take it one step further. I now have every month for every year in a separate column. I'd like previous years to be grouped into a summary column but the current year displayed month by month.


Thanks for any help
NeoOffice 2.2.3 with MacOS 10.4
psdel
 
Posts: 1
Joined: Sun Jan 12, 2020 11:51 pm

Re: Resources for getting better with pivot tables?

Postby Villeroy » Mon Jan 13, 2020 8:29 pm

psdel wrote:This did what I wanted but I want to take it one step further. I now have every month for every year in a separate column. I'd like previous years to be grouped into a summary column but the current year displayed month by month.


Thanks for any help

Make 2 pivot tables. One for the years, one for years and months.

[Edit]I forgot to mention that a database can create such an aggregation easily using a UNION SELECT statement aggregating past years and appending the aggregates of recent months[Edit]
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28641
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 28 guests