Print Page - Get Weekly Data

Title: Get Weekly Data
Post by: santosh.yelugoi on 24 Apr 2013 11:32:50 PM

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

Title: Re: Get Weekly Data
Post by: raj_aries on 26 Apr 2013 02:20:15 PM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: santosh.yelugoi on 24 Apr 2013 11:32:50 PM