YOY% Inc

[tracycrown]

Dear all

Kindly advise how to compute YOY% increase by products.

Correct Answer should be as follow :

Product	Year	$	YOY%
A10884	2015	23000	0%
A10884	2016	18000	-22%
A10884	2017	15000	-17%
B64592	2015	17000	0%
B64592	2016	24000	41%
B64592	2017	32000	33%

Thank You

Tracy

[antoniotiman · Accepted solution]

Hi Tracy,

see Attachment,

Regards,

Antonio.

[prma7799]

PFA

[pathiqvd]

Hi,

    Use below expr you will get solution:-

num((sum(Sales)-above(sum(Sales)))/above(sum(Sales)),'##.## %')

Regards,