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.


Tagged:

Answers