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

WEEK OVER WEEK SALES VARIANCE ON SAS VA - CROSSTAB

Reply
Contributor
Posts: 21

WEEK OVER WEEK SALES VARIANCE ON SAS VA - CROSSTAB

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:

  • Transaction Date (MMDDYYY)
  • Transaction End of Week Dt (MMDDYYY)
  • Transaction Week (Numeric)
  • Amount (Dollar)
  • Day of Week (Character)

week over week.PNG

 

I tried multiple formulas and nothing seems to work.

 

Thanks, 

 

CJ

SAS Employee
Posts: 19

Re: WEEK OVER WEEK SALES VARIANCE ON SAS VA - CROSSTAB

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

Contributor
Posts: 21

Re: WEEK OVER WEEK SALES VARIANCE ON SAS VA - CROSSTAB

Posted in reply to ShannonMoore

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

Thanks 

Ask a Question
Discussion stats
  • 2 replies
  • 323 views
  • 0 likes
  • 2 in conversation