How add aggregate measure and conditions in SAS VA Cross Tab

[srinivaschary]

Dataset:

Month	Location	Production	Pended	Pended%
JAN'17	Hyd	12	3	20%
FEB'17	Che	15	2	12%
MAR'17	Vel	30	4	12%
APR'17	Delhi	23	1	4%
MAY'17	Hyd	32	2	6%
JUN'17	che	45	1	2%
JAN'17	Hyd	12	3	20%
FEB'17	Che	15	2	12%
MAR'17	Vel	30	4	12%
APR'17	Delhi	23	1	4%
MAY'17	Hyd	32	2	6%
JUN'17	che	45	1	2%
JAN'17	Hyd	12	3	20%
FEB'17	Che	15	2	12%
MAR'17	Vel	30	4	12%
APR'17	Delhi	23	1	4%
MAY'17	Hyd	32	2	6%
JUN'17	che	45	1	2%
JAN'17	Hyd	12	3	20%
FEB'17	Che	15	2	12%
MAR'17	Vel	30	4	12%
APR'17	Delhi	23	1	4%
MAY'17	Hyd	32	2	6%
JUN'17	che	45	1	2%

Expected Result:

[bpazzaglini]

You could create a new measure (see you if it's better a new calculated itam or a new aggregated measure) that consider the diffence between the last month and the sum of the last three month.
Applay as visualization rule this difference to the column that you wish