Calculating YoY and QoQ in Pivot Table
I am trying to create a pivot table displaying QoQ and YoY revenue growth over the span of 6 quarters by product, but I am having difficulties building out the proper beastmode to show every quarter simulateanously. I have tried to use some suggested formulas (example: https://dojo.domo.com/t5/Domo-Dojo-Contest-January-2016/quot-Best-Beast-Mode-Formula-quot-Year-over-Year-Change/idi-p/7933) but it will not work for the previous quarters. Would anyone have any suggestions as to where I should start?
For the purpose of clarifying what I would like to design, I built out a simplistic practice pivot table attached below. Fairly new to the DOMO community, any help would be appreciated.