Grouping Pivot Table by week, including every week

asked 2018-02-23 18:48:17 +0200

samvimes gravatar image

Hi all,

I have a spreadsheet which contains events and their date. I now want a pivot table which shows me the number of events/week for all weeks of the year.

If I create a pivot table and group it by week, however, only weeks for which the count of events is 1 or higher are included. How can I get Calc to include all weeks, even those without an event?

Thank you in advance!

edit retag flag offensive close merge delete

Comments

Does your spreadsheet actually include weeks that have no event? In other words, is there a "zero" for each of the weeks without an event?

ve3oat gravatar imageve3oat ( 2018-02-25 03:51:39 +0200 )edit