While you can accomplish this with a single table, I would not suggest it. In order to do a proper comparison on a value at different time periods - year over year, month to month, etc - you will need a table that represents the time period you are reporting on, Years for example. Each record on this table would represent a single Year and would need to be connected via a Relationship where Years would be the Parent table. Once you have this setup, you can build Summary fields up to the Year record for each field you would like to report on.
Once your basic structure is in place, you can build additional circular relationships on your Years table for Prior Year, 2 Years Prior, or whatever timeframe you need to compare. You would then bring over those same fields as Lookups from the Prior Year record and build formulas to calculate your YOY values.
------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
Original Message:
Sent: 09-15-2020 14:33
From: George Bramhall
Subject: YOY % of This Year and Last Year
Anyone have an idea how to show (calculate) a YOY % change from 2019 to 2020 for each Heading (e.g AGHM) in this Summary Report?
------------------------------
George Bramhall
------------------------------