Skip to content
DB Calc Q
two tables to demonstrate principle
Two tables
We'll be working with two tables. The first table below shows the store names, the month, and the monthly sales. It also has a column with quarterly results. I find that this monthly table makes calculations much easier than other methods that use the "remainder" function. This is our starting point. As promised, we need a second table to present the data in a usable way. This second table has columns for Q1, Q2, Q3, and Q4, as well as additional columns for the store and year. So we have a row with the store, year, and then Q1, Q2, Q3, and Q4. This reporting table will make it easier to see the results. See how it works, you'll be surprised, and I hope you can use it in your own system
fill out reporting table
DB Q Rep
Name
shop
yr
Q1
Q2
Q3
Walmart 2025 per Q
Walmart
2025
$480,599.00
$732,528.00
$603,471.00
$559,024.00
€2,375,622.00
Home Depot 2025 per Q
Home Depot
2025
$532,447.00
$747,685.00
$752,503.00
$584,331.00
€2,616,966.00
Target 2025 per Q
Target
2025
$422,341.00
$633,456.00
$374,574.00
$678,357.00
€2,108,728.00
Dollar General 2025 per Q
Dollar General
2025
$512,107.00
$421,798.00
$615,341.00
$808,777.00
€2,358,023.00
There are no rows in this table
View of DB Q Rep
DB Calc Q
Walmart - January €182,883.00
Walmart
2025
January
€182,883.00
$480,599.00
Walmart - February €95,662.00
Walmart
2025
February
€95,662.00
$480,599.00
Walmart - March €202,054.00
Walmart
2025
March
€202,054.00
$480,599.00
There are no rows in this table
View of DB Calc T
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.