Hello, wondering if these is a way to compare quarter over quarter results in a table with only 1 quarter selected at a time. I for the calculation to work in quick table calculations as long as i had all quarters in a row on the table. However i would like a user to select the quarter they wish to look at (one quarter at a time only) , and it provide YoY results and also vs. previous quarter results. I basically want the table to the left to be in similar format as the one on the right with QoQ being Quarter over Quarter.
THe data is layed out in this structure