Hey there, Is there a easy way to add YoY-month columns to pivot tables? In the following example, for instance, I would like to show the YoY comparing Feb-24 with Feb-23, Jan24-Jan23, Dec23-Dec22, etc. [Screenshot 2024-02-13 at 12.35.58] Any assistance would be greatly appreciated.

Hi @acallea I’m not sure if this is suitable for you, but I calculate month by month in this way, with this output ifelse( extract(“MM”, CreatedDate)=1,“(a) GENNAIO”, extract(“MM”, CreatedDate)=2,“(b) FEBBRAIO”, extract(“MM”, CreatedDate)=3,“(c) MARZO”, extract(“MM”, CreatedDate)=4,“(d) APRILE…

How to calculate YoY-month and add it to pivot table?

Question & Answer

andreab February 13, 2024, 3:01pm 2

Hi @acallea

I think this link can help you - Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Andrea

1 Like

Topic		Replies	Views
YoY Comparision without a Date field Question & Answer analysis , calculations , Business-Intelligence-Engineer	10	400	January 10, 2024
Pivot table by year and add difference colum Question & Answer how-to	3	324	August 30, 2023
How to add month over month percentage difference in Pivot table when the table sorted Question & Answer calculations , pivot-table , how-to	2	600	March 13, 2023
YoY% , MoM% and QoQ% calculation for numeric month and year values Question & Answer formatting , calculations , how-to	6	2933	January 18, 2023
Add MoM% for each column in Pivot table Question & Answer calculations , how-to	1	310	June 5, 2023

How to calculate YoY-month and add it to pivot table?

Related topics