https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-Custom-Variance-for-only-two-dates-out-of-six-available/m-p/463762#M10244 <P>Hi,</P><P>&nbsp;</P><P>I'm having a problem in creating a report (Crosstab) having Two Categories (1. Parameters like (Savings Bank,current Account etc ) - Rows , 2. dates(Different Dates total six dates like Quarter5,quarter4,quarter3,quarter2,quarter1, Previous date, Current Date).</P><P>&nbsp;</P><P>Now I need to caluculate variance on only two columns such as current date and previous date.</P><P>&nbsp;</P><P>It would be great help for guiding me.</P><P>&nbsp;</P><P>Regards</P><P>&nbsp;</P><P>Chandu.</P><P>&nbsp;</P><P>&nbsp;</P><P>I&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/20650iE7A1731F01456C8C/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.JPG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/20651iA437137092B24ADE/image-size/large?v=v2&amp;px=999" role="button" title="Capture1.JPG" alt="Capture1.JPG" /></span></P> Mon, 21 May 2018 12:21:19 GMT ChanduMV 2018-05-21T12:21:19Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-Custom-Variance-for-only-two-dates-out-of-six-available/m-p/463762#M10244 <P>Hi,</P><P>&nbsp;</P><P>I'm having a problem in creating a report (Crosstab) having Two Categories (1. Parameters like (Savings Bank,current Account etc ) - Rows , 2. dates(Different Dates total six dates like Quarter5,quarter4,quarter3,quarter2,quarter1, Previous date, Current Date).</P><P>&nbsp;</P><P>Now I need to caluculate variance on only two columns such as current date and previous date.</P><P>&nbsp;</P><P>It would be great help for guiding me.</P><P>&nbsp;</P><P>Regards</P><P>&nbsp;</P><P>Chandu.</P><P>&nbsp;</P><P>&nbsp;</P><P>I&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/20650iE7A1731F01456C8C/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.JPG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/20651iA437137092B24ADE/image-size/large?v=v2&amp;px=999" role="button" title="Capture1.JPG" alt="Capture1.JPG" /></span></P> Mon, 21 May 2018 12:21:19 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-Custom-Variance-for-only-two-dates-out-of-six-available/m-p/463762#M10244 ChanduMV 2018-05-21T12:21:19Z