How to calculate (1-30 days ,31-60,61-90…..)revunue in webi

Hi ,

I want to calculate measures between days ex(1-30 days,31-60days, 61-90days like…) in webi report  for user given date.

now i am  using relative position to implementing above requirement but not sure it ll give right data . if you have any other logic please provide solution.

1-30days  Name called  V1

=RelativeDate([vUser Date];-30)

31-60days   V2

=RelativeDate([V1];-60)   

1- 30 days measure calculation

=[Hours Worked] Where ([Pay Period Ending Date]<=[vUser Date] And [Pay Period Ending Date]>[V1])

31- 60 days measure calculation

=[Hours Worked] Where ([Pay Period Ending Date]<=[vUser Date] And [Pay Period Ending Date]>[V2])

Thanks,

S Suryateja.