Get Weekly Data

[santosh.yelugoi]

Hi All,

I want to create List report where i want to show the data as shown in attached document.
Could you please advise me or provide the solution so that i can create the rpeort.

Regards,
Santosh

[raj_aries]

Hi Santosh

Group it by Week# and then in second column take max([date] for Week#). This will give you the max date for that week. Total([sales1] for week#) gives you the measure value

Regards
Raj