Hello All,
I have tried searching for this issue. I have below scenario where i need to get last week data for a calculation in cross tab report.
Example:
Title Week periods: .......6/26/2016 7/3/2016 7/10/2016 Calculation
A 8 12 20 20*(******)
B 10 45 30 30 *(****)
C 5 8 3 3*(***)
This is YTD report and, If i run report today7/15/2016 i want to bring last week data i.e 7/10/2016. Can any one help how to achieve this.
Any ideas would be appreciated.
Thank You,
Venkat