Pivot Tables and Porcentages

[Frank123]

So I have a data base that has:
1. Months
2. Sales This year
3. Sales Last Year
4. % of variation calculated like this: (Sales This Year/Sales Last Year -1)

My problem is that when I use a Pivot Table and put months in filter as All Selected, the variation is incorrect.

If I configure the pivot table for it to show % of variation as an average it also dosent match my 12%.

So how do you guys, recomend I manage porcentage when it comes to Pivot Tables?

 

[GraH]

This might explain what's the issue (normal pivot used).

Book1
	B	C	D	E	F	G	H	I	J	K
1	month	Sales	Year				Column Labels
2	jan	100	2024				2023		2024
3	feb	70	2024			Row Labels	Sum of Sales2	% Of Prev Yr	Sum of Sales2	% Of Prev Yr
4	ma	300	2024			jan	50		100	100,00%
5	jan	50	2023			ma	250		300	20,00%
6	feb	120	2023			feb	120		70	-41,67%
7	ma	250	2023			Grand Total	420		470	11,90%
Sheet1

But you refer to all selected. So, are you using Power Pivot or the data model? -> Share you measure, so we at least understand how you wrote the DAX formula.
PS: You do not need the calculation in the source data.