I you want to get the previous weeks values you can use "lookup" function (e.g ""ZN(LOOKUP(SUM([Sales]),-1))"" ).
Let me know if it is helpful.
Thanks for answering but it didn't work. I don't want to shift and get a value from the view, I really want to calculate the number of users who connected last week for each week from week 2 to the last week.
Would it be possible for you to provide a sample workbook/dataset.