Logic help related to Current Week Vs last Year Week.

[lalitkgehlot89]

Hi,

In Sample data I have three Fields, Storeid, Date & Sales Amount.

I want to make a Straight table which show sales data of current week and last year same week sales data.

And first week should be from 1Jan and after that secound,third,fourth... should be start from Monday.

for more reference data given in weekcal file.

Please help me out to create the logic for the same.

Thanks,

Lalit Kumar

[lalitkgehlot89]

This one will not work on next week.

[avkeep01]

Yes, you would make week={48} dynamically.

2 examples:

- SUM({$<_CurrentYear={1},Week={$(=MAX(Week))}>} Amount)  // based on selection

- Create variable: vWeek = MAX(Week)

  SUM({$<_LastYear={1},Week={$(vWeek)}>} Amount).