topic Pivot Table Add Column YoY By Month in App Development

Pivot Table Add Column YoY By Month

newuser — Sat, 16 Nov 2024 21:28:15 GMT

Hello - I've searched the forums about this question but haven't arrived at a clear answer yet:

Say I have a pivot table that has one dimension as a row, and TWO columns: first by month (Jan, Feb, Mar), then by year. What I’m trying to do is calculate YoY within month. When I add an expression to the pivot table, it is calculating for each year, when I want it to calculate by month. Plus not 100% sure of the proper syntax.

The data has more than two years, so the calculated column has to be “smart” enough to handle whichever two years the user chooses.

Any ideas? Example of what the final pivot table should look like - the first row is just for clarity indicating the month column.

	Jan	Jan	Jan	Feb	Feb	Feb
	Year1	Year2	YoY	Year1	Year2	Yoy
Dimension value1
Dimension value2

Thanks for any tips you can provide!

Re: Pivot Table Add Column YoY By Month

Channa — Tue, 05 Feb 2019 11:21:19 GMT

there are some based on ROW

using above function try column 1/column2

there is function Column(1)/Column(2)

may be

Re: Pivot Table Add Column YoY By Month

newuser — Thu, 07 Feb 2019 13:47:10 GMT

Tried that and got zeros. So am trying something different - the measure below I've added to return the amount for max year. I have it where month is the only column. The expression "Yr" has the year. The set expression below is not recognizing max year. Instead it is summing across all years. Any ideas?

Sum({$<Yr={$(=max(Yr))}> }amount)