Pivot table by year and add difference colum

Q&A
1

In the left, the data I currently have. In the right, what I am trying to achieve.
Goal is to split every month into years and create a new column with the difference by year.

image
image1150×195 5.53 KB

I can achieve this by creating calculated fields. One for jan_22, one for jan_23 and one for jan_difference. But 12 moths * 3 calculated fields each is 36 calculated fields. I am looking for more efficient ways to achieve this. I have not been able to make it work with a pivot table.

2

Can you make a calculated field that extracts the month, then the year?

Month field

extract('MM',{date})

Year field

extract('YYYY',{date})

Then you should be able to add your value.

In regards to a difference, you might be able to do that with a calculated field or table calculation.

image
image896×632 40.5 KB

3

Hi @Nickson40 Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 7 days, we will archive the question