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

[acallea]

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.

Any assistance would be greatly appreciated.

[andreab]

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

[acallea]

Thanks Andrea! There I can see how to calculate the Monthly YoY % Diff for current month, but not really how I could add it to a pivot table and show that YoY for every month. Any clue?

[andreab]

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”,
extract(“MM”, CreatedDate)=5,“(e) MAGGIO”,
extract(“MM”, CreatedDate)=6,“(f) GIUGNO”,
extract(“MM”, CreatedDate)=7,“(g) LUGLIO”,
extract(“MM”, CreatedDate)=8,“(h) AGOSTO”,
extract(“MM”, CreatedDate)=9,“(i) SETTEMBRE”,
extract(“MM”, CreatedDate)=10,“(l) OTTOBRE”,
extract(“MM”, CreatedDate)=11,“(m) NOVEMBRE”,
extract(“MM”, CreatedDate)=12,“(n) DICEMBRE”,
“altro”
)

[acallea]

Thanks Andrea, I was looking if there was a way to use existing functions to that use case, but that is also helpful!