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

    weekday on weekday percentage change




      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