Skip to Content
0
Former Member
Jul 15, 2016 at 02:28 PM

Last week data in cross tab?

29 Views

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