Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How add aggregate measure and conditions in SAS VA Cross Tab

Reply
Occasional Contributor
Posts: 8

How add aggregate measure and conditions in SAS VA Cross Tab

Dataset:

MonthLocationProductionPendedPended%
JAN'17Hyd12320%
FEB'17Che15212%
MAR'17Vel30412%
APR'17Delhi2314%
MAY'17Hyd3226%
JUN'17che4512%
JAN'17Hyd12320%
FEB'17Che15212%
MAR'17Vel30412%
APR'17Delhi2314%
MAY'17Hyd3226%
JUN'17che4512%
JAN'17Hyd12320%
FEB'17Che15212%
MAR'17Vel30412%
APR'17Delhi2314%
MAY'17Hyd3226%
JUN'17che4512%
JAN'17Hyd12320%
FEB'17Che15212%
MAR'17Vel30412%
APR'17Delhi2314%
MAY'17Hyd3226%
JUN'17che4512%

 

Expected Result:

Expected result.png

Occasional Contributor
Posts: 9

Re: How add aggregate measure and conditions in SAS VA Cross Tab

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
Post a Question
Discussion Stats
  • 1 reply
  • 125 views
  • 0 likes
  • 2 in conversation