2 Replies Latest reply on Oct 4, 2012 12:48 PM by nickster

    weekday on weekday percentage change

    nickster

      Hello,

       

      I am trying to track weekday on weekday percentage change (against a moving average of transaction volume). I have created a sample data file with 4 weeks of data. i would like a view in which I can see date of transaction and a percentage change of average transaction volume by weekday.

       

      My data is sensitive to different days of the week, and i would like to compare like with like, but I can't figure out how to do this with a table calculation. I have tried using the lookup function for a running sum that references 7 rows prior, but this isn't getting me what I need.

       

      Any help would be appreciated. txbx attached

       

      Thanks

      N