topic WEEK OVER WEEK SALES VARIANCE ON SAS VA - CROSSTAB in SAS Visual Analytics

WEEK OVER WEEK SALES VARIANCE ON SAS VA - CROSSTAB

chrisjab — Thu, 27 Oct 2016 16:44:03 GMT

Hello All,

I am trying to calculate and incorporate a week over week sales variance on SAS VA and I am having some difficulties.

Currently I have the following data:

I tried multiple formulas and nothing seems to work.

Thanks,

ShannonMoore — Tue, 01 Nov 2016 21:17:52 GMT

CJ, This seems related to your other post with reference to varience. Is it similar and if so, have our suggestions helped? Shannon

chrisjab — Wed, 02 Nov 2016 13:03:07 GMT

Hello Shannon I did try your formula; however when I include multiple categories I am not get the right variance.

Thanks