Sum vs Previous Sum By Years, %

[Death4Free]

Hi! How can I calculate measure in pivot table - Sales Vs Prev. sales, % ( there could be more years, and i have Calendar Master if it helps)?

	2016		2017		2018
	Sales	Sales Vs Prev. sales, %	Sales	Sales Vs Prev. sales, %	Sales	Sales Vs Prev. sales, %
dec	10	100%	12	120%	10	83%
jan	9	100%	6	66%	8	133%
feb	15	100%	16	106%	18	113%

[felipedl · Accepted solution]

Hi Aleksandrs,

loading as an example the data you posted, like so:

l

oad * Inline
[
Month,Year,Sales
dec,2016,10
dec,2017,12
dec,2018,10
jan,2016,9
jan,2017,6
jan,2018,8
feb,2016,15
feb,2017,16
feb,2018,18
];

You can get it by using the before statement: before(sum(Sales)).

What it does, on a pivot table, is to get the previous (left) value.

Using the expression, I got:

See the attached QVW for example and further expressions that I added.

[Death4Free]

Thank you for help