Skip to content
Gallery
huizer-blue-q
Quarter logic
Quarter logic
DB Calc Q
Share
Explore

DB Calc Q

two tables to demonstrate principle
megaphone

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
Q4
yearly turn over
Walmart 2025 per Q
Walmart
$480,599.00
$732,528.00
$603,471.00
$559,024.00
€2,375,622.00
Home Depot 2025 per Q
Home Depot
$532,447.00
$747,685.00
$752,503.00
$584,331.00
€2,616,966.00
Target 2025 per Q
Target
$422,341.00
$633,456.00
$374,574.00
$678,357.00
€2,108,728.00
Dollar General 2025 per Q
Dollar General
$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
Name
shops
yr
months
turnO
quarterly
Walmart - January €182,883.00
Walmart
€182,883.00
$480,599.00
Walmart - February €95,662.00
Walmart
€95,662.00
$480,599.00
Walmart - March €202,054.00
Walmart
€202,054.00
$480,599.00
Walmart - April €287,167.00
Walmart
€287,167.00
$732,528.00
Walmart - May €221,337.00
Walmart
€221,337.00
$732,528.00
Walmart - June €224,024.00
Walmart
€224,024.00
$732,528.00
Walmart - July €189,964.00
Walmart
€189,964.00
$603,471.00
Walmart - August €238,775.00
Walmart
€238,775.00
$603,471.00
Walmart - September €174,732.00
Walmart
€174,732.00
$603,471.00
Walmart - October €174,955.00
Walmart
€174,955.00
$559,024.00
Walmart - November €218,283.00
Walmart
€218,283.00
$559,024.00
Walmart - December €165,786.00
Walmart
€165,786.00
$559,024.00
Home Depot - January €110,854.00
Home Depot
€110,854.00
$532,447.00
Home Depot - February €228,339.00
Home Depot
€228,339.00
$532,447.00
Home Depot - March €193,254.00
Home Depot
€193,254.00
$532,447.00
Home Depot - April €257,527.00
Home Depot
€257,527.00
$747,685.00
Home Depot - May €239,991.00
Home Depot
€239,991.00
$747,685.00
Home Depot - June €250,167.00
Home Depot
€250,167.00
$747,685.00
Home Depot - July €291,304.00
Home Depot
€291,304.00
$752,503.00
Home Depot - August €263,187.00
Home Depot
€263,187.00
$752,503.00
Home Depot - September €198,012.00
Home Depot
€198,012.00
$752,503.00
Home Depot - October €205,617.00
Home Depot
€205,617.00
$584,331.00
Home Depot - November €102,370.00
Home Depot
€102,370.00
$584,331.00
Home Depot - December €276,344.00
Home Depot
€276,344.00
$584,331.00
Target - January €144,567.00
Target
€144,567.00
$422,341.00
Target - February €120,314.00
Target
€120,314.00
$422,341.00
Target - March €157,460.00
Target
€157,460.00
$422,341.00
Target - April €92,731.00
Target
€92,731.00
$633,456.00
Target - May €269,289.00
Target
€269,289.00
$633,456.00
Target - June €271,436.00
Target
€271,436.00
$633,456.00
Target - July €94,782.00
Target
€94,782.00
$374,574.00
Target - August €144,051.00
Target
€144,051.00
$374,574.00
Target - September €135,741.00
Target
€135,741.00
$374,574.00
Target - October €295,790.00
Target
€295,790.00
$678,357.00
Target - November €264,413.00
Target
€264,413.00
$678,357.00
Target - December €118,154.00
Target
€118,154.00
$678,357.00
Dollar General - January €261,597.00
Dollar General
€261,597.00
$512,107.00
Dollar General - February €104,226.00
Dollar General
€104,226.00
$512,107.00
Dollar General - March €146,284.00
Dollar General
€146,284.00
$512,107.00
Dollar General - April €141,119.00
Dollar General
€141,119.00
$421,798.00
Dollar General - May €172,441.00
Dollar General
€172,441.00
$421,798.00
Dollar General - June €108,238.00
Dollar General
€108,238.00
$421,798.00
Dollar General - July €278,404.00
Dollar General
€278,404.00
$615,341.00
Dollar General - August €130,503.00
Dollar General
€130,503.00
$615,341.00
Dollar General - September €206,434.00
Dollar General
€206,434.00
$615,341.00
Dollar General - October €235,594.00
Dollar General
€235,594.00
$808,777.00
Dollar General - November €284,283.00
Dollar General
€284,283.00
$808,777.00
Dollar General - December €288,900.00
Dollar General
€288,900.00
$808,777.00
There are no rows in this table
⁠
View of DB Calc T
⁠


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.