Calculating MoM, YoY, YTD in table
Hi Domo users, I have been trying to figure out how to represent some values in a revenue table and hoping you can help. Here is what I have so far:
As you can see above, I have something like this cable that I want to replicate in Domo. For the most part I can do this in a pivot table in Domo, however I am not sure how to get the MoM (Change between October and September given that October is the current month) and YTD (July is the beginning of the fiscal year so would be a calculation of all of the total of all of the months) and YoY (difference between October last year and this year).
Is this possible to achieve?Hoping someone can help. So far here is my Pivot table in Domo which produces the revenue table, however not the last calculations.
Answers

Hi @mroker ,
So first, you'll need to do a bit of data cleanup. Having the names of the months at the top isn't the best hygiene, but I have you covered. If you can get your data to just be Category, Date, Sales, that's cleaner. If not, you can transform it. Anyway, after that, you just need some basic formulas to get MTD, YTD and YOY.
I made a video for you showing you how to do it: https://www.loom.com/share/f0dfe27e114d4eda8ed4933449bf1197
Best,
John Le
You're only one dashboard away.
More video solutions at: https://www.dashboarddudes.com/pantry
0
Categories
 7.3K All Categories
 13 Getting Started in the Community
 141 Beastmode & Analytics
 1.8K Data Platform & Data Science
 54 Domo Everywhere
 2K Charting
 1K Ideas Exchange
 903 Connectors
 236 Workbench
 342 APIs
 77 Apps
 19 Governance & Productivity
 235 Use Cases & Best Practices
 50 News
 473 Onboarding
 572 日本支部