Grouping Pivot Table by week, including every week

[samvimes]

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!

[ve3oat]

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?