Set Analysis - percentage variation same month previous year

[Anonymous]

Hi,

I need help. I tell you what happens to me:

I have a Linktable with data of different months and years with the following fields.

AñoMes	Vta	% Vta (ma)
201601	100,95	0.00%
201602	99,25	0.00%
.	.	.
.	.	.
201701	150,85	49,43%
201702	160,25	61,46%
.	.	.
.	.	.
201801	200,25	32,74%
201802	150,79	-5,90%

I need % Vta c/vat, it is feasible for the variation of the Data 201801 in respect of one of 201701, and thus for all records.

I'm stuck !!

Thank you very much in advance

Regards

[sunny_talwar]

Best way to handle this would be to use The As-Of Table

[Anonymous]

Thank you very much for Info.

I´ll try to do it as soon as possible.

Just only 1 more question. It would be posible to resolve in Set Analysis?

Regards

[sunny_talwar · Accepted solution]

AFAIK it won't.... you can look into Above/Below function in case you don't want to do it in the script

Missing Manual - Above() and Below()

[Anonymous]

Ok thanks I´ll do it

[Anonymous]

It works perfect!!

Thank you very very very much!!