Skip to content

Cookie settings

Choose which kinds of cookies you allow. You can change your choice at any time via Cookie settings at the bottom of every page. Privacy statement

Necessary

Always on

Needed to log in, keep your cart and remember your choices. These are always on.

Which cookies?
  • weboke_sessie, weboke_klant, weboke_remember: your session and staying logged in
  • weboke_basket: your cart
  • wkBtwIncl: showing prices with or without VAT
  • wok_cookies: your cookie choice, 12 months

Measures which ad leads to a visit or order, so we do not pay for ads that do nothing.

Which cookies?
  • Google Ads via Google Tag Manager (_gcl_au, _gcl_aw), up to 90 days
  • OpenAI Ads, ads in ChatGPT
  • wok_aff: which partner referred you to us (affiliate programme), 60 days

4.6

Country and language

Each country has its own site, with prices and VAT for that country.

View

A pivot table by month, quarter or week

You've created a pivot table from a sales list (see Pivot tables) with the date under Rows. The result is an endless list with one line per day. What you want is a total per month or per quarter, per year. You do that with Group.

As an example, we use the sales of Bloemisterij Het Zonnetje for 2025 and 2026: the date in A, the product in B, the category in C and the amount in D.

Step 1: the pivot table

  1. Select the list including the header row, only the filled rows, and on the Insert tab choose Pivot Table. In the Create pivot table window, leave New sheet selected and click OK.
  2. On the right, under Select fields, tick the Date field. It goes to Rows.
  3. Click the arrow to the right of the Amount field and choose Add to values.
The arrow next to a field
Use the arrow next to Amount to choose Add to values

If you then see Count of Amount instead of Sum of Amount, the pivot table is counting the number of sales instead of adding up the amounts. This happens if you also selected empty rows below the list. Right-click a number in the pivot table and choose Summarize values by, Sum. If it stays on Count, create the pivot table again and select only the filled rows.

Summarize values by
Right-click a number: Summarize values by, Sum

Step 2: group by month

  1. Right-click a date in the pivot table and choose Group.
  2. In the Grouping window, Starting at and Ending at show the first and last date. Leave them as they are.
  3. Under By there's a list of intervals; Months is already selected. Hold down Ctrl and also click Years, so both are selected. If you click without Ctrl, you replace Months with Years.
  4. Click OK.
The Grouping window
Under By you choose the interval; with Ctrl you can choose several at once

Why Years as well? If you choose only Months, the pivot table adds January 2025 and January 2026 together in a single Jan line.

Only Months selected
With only Months, January 2025 and January 2026 end up together in the Jan line

By quarter

Right-click a date again, choose Group, click Quarters and, holding Ctrl, also Years. You get the quarters for each year, which Euro-Office calls Qtr1 to Qtr4.

Quarters and Years selected together
Quarters and Years selected with Ctrl
The pivot table by year and quarter
The quarters for each year with a subtotal per year. This still shows Count of Amount: the number of sales. With Summarize values by, Sum they become amounts

Compare with last year

Right-click an amount in the pivot table and choose Show values as. Options there include % of grand total, Difference from and % Difference from. With the last one you can see, for example, by what percentage one quarter is higher or lower than another.

Show values as
The calculations you can apply to the amounts

By week

In the Grouping window, choose only Days and set Number of days to 7. The weeks then start on the date under Starting at; enter a Monday there if you want weeks from Monday to Sunday. Note: these are blocks of 7 days, not calendar week numbers. If you want real week numbers, add a helper column with the week label to the list (see ISO week numbers, including around the turn of the year) and put it under Rows.

Grouping by 7 days
Only Days selected and Number of days set to 7

Removing the grouping

Right-click a month or quarter in the pivot table and choose Ungroup. The same menu also contains Group and Refresh.

The right-click menu in the pivot table
Including Refresh, Group and Ungroup

Pitfalls

  • A (blank) line and Count instead of Sum: you also selected empty rows below the list. Select only the filled rows.
  • New sales don't show up: a pivot table doesn't refresh automatically. Right-click in the pivot table and choose Refresh.

One moment…

Set up your domains

For each domain, arrange the nameservers, the link to your hosting and who becomes the owner.

Loading your domains…