topic Re: How add aggregate measure and conditions in SAS VA Cross Tab in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/How-add-aggregate-measure-and-conditions-in-SAS-VA-Cross-Tab/m-p/349435#M6889 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.<BR />Applay as visualization rule this difference to the column that you wish Wed, 12 Apr 2017 13:15:22 GMT bpazzaglini 2017-04-12T13:15:22Z How add aggregate measure and conditions in SAS VA Cross Tab https://communities.sas.com/t5/SAS-Visual-Analytics/How-add-aggregate-measure-and-conditions-in-SAS-VA-Cross-Tab/m-p/343587#M6685 <P>Dataset:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Month</TD><TD>Location</TD><TD>Production</TD><TD>Pended</TD><TD>Pended%</TD></TR><TR><TD>JAN'17</TD><TD>Hyd</TD><TD>12</TD><TD>3</TD><TD>20%</TD></TR><TR><TD>FEB'17</TD><TD>Che</TD><TD>15</TD><TD>2</TD><TD>12%</TD></TR><TR><TD>MAR'17</TD><TD>Vel</TD><TD>30</TD><TD>4</TD><TD>12%</TD></TR><TR><TD>APR'17</TD><TD>Delhi</TD><TD>23</TD><TD>1</TD><TD>4%</TD></TR><TR><TD>MAY'17</TD><TD>Hyd</TD><TD>32</TD><TD>2</TD><TD>6%</TD></TR><TR><TD>JUN'17</TD><TD>che</TD><TD>45</TD><TD>1</TD><TD>2%</TD></TR><TR><TD>JAN'17</TD><TD>Hyd</TD><TD>12</TD><TD>3</TD><TD>20%</TD></TR><TR><TD>FEB'17</TD><TD>Che</TD><TD>15</TD><TD>2</TD><TD>12%</TD></TR><TR><TD>MAR'17</TD><TD>Vel</TD><TD>30</TD><TD>4</TD><TD>12%</TD></TR><TR><TD>APR'17</TD><TD>Delhi</TD><TD>23</TD><TD>1</TD><TD>4%</TD></TR><TR><TD>MAY'17</TD><TD>Hyd</TD><TD>32</TD><TD>2</TD><TD>6%</TD></TR><TR><TD>JUN'17</TD><TD>che</TD><TD>45</TD><TD>1</TD><TD>2%</TD></TR><TR><TD>JAN'17</TD><TD>Hyd</TD><TD>12</TD><TD>3</TD><TD>20%</TD></TR><TR><TD>FEB'17</TD><TD>Che</TD><TD>15</TD><TD>2</TD><TD>12%</TD></TR><TR><TD>MAR'17</TD><TD>Vel</TD><TD>30</TD><TD>4</TD><TD>12%</TD></TR><TR><TD>APR'17</TD><TD>Delhi</TD><TD>23</TD><TD>1</TD><TD>4%</TD></TR><TR><TD>MAY'17</TD><TD>Hyd</TD><TD>32</TD><TD>2</TD><TD>6%</TD></TR><TR><TD>JUN'17</TD><TD>che</TD><TD>45</TD><TD>1</TD><TD>2%</TD></TR><TR><TD>JAN'17</TD><TD>Hyd</TD><TD>12</TD><TD>3</TD><TD>20%</TD></TR><TR><TD>FEB'17</TD><TD>Che</TD><TD>15</TD><TD>2</TD><TD>12%</TD></TR><TR><TD>MAR'17</TD><TD>Vel</TD><TD>30</TD><TD>4</TD><TD>12%</TD></TR><TR><TD>APR'17</TD><TD>Delhi</TD><TD>23</TD><TD>1</TD><TD>4%</TD></TR><TR><TD>MAY'17</TD><TD>Hyd</TD><TD>32</TD><TD>2</TD><TD>6%</TD></TR><TR><TD>JUN'17</TD><TD>che</TD><TD>45</TD><TD>1</TD><TD>2%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Result:</P><P><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/7918i713204BEFE6EC1AF/image-size/original?v=1.0&amp;px=-1" border="0" alt="Expected result.png" title="Expected result.png" /></P> Thu, 23 Mar 2017 03:25:29 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-add-aggregate-measure-and-conditions-in-SAS-VA-Cross-Tab/m-p/343587#M6685 srinivaschary 2017-03-23T03:25:29Z Re: How add aggregate measure and conditions in SAS VA Cross Tab https://communities.sas.com/t5/SAS-Visual-Analytics/How-add-aggregate-measure-and-conditions-in-SAS-VA-Cross-Tab/m-p/349435#M6889 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.<BR />Applay as visualization rule this difference to the column that you wish Wed, 12 Apr 2017 13:15:22 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-add-aggregate-measure-and-conditions-in-SAS-VA-Cross-Tab/m-p/349435#M6889 bpazzaglini 2017-04-12T13:15:22Z