How to show report Weekly basis

[narender123]

Hi Team,

i want to make a weekly report for revenue collection for current week of this year Vs last year for current week.Please guide me .

WEEKLY REVENUE COLLECTION
14th June	15th June	16th June	17th June	18th June	19th June	20th June
$33,252.03	$2,105.21	$149.14	$56,502.98	$51,347.33	$69,520.75	$76,880.61
TOTAL REVENUE COLLECTION						$2,76,758.05
TOTAL REVENUE COLLECTION 2012						$2,64,304.95

Thanks in advance.

Narender

[narender123]

Hi All,

Its first time that i am handling with weekly report.please give me some idea??

[narender123]

Hi Team,

Is it possible to show report like this ,if yes then some one could tell me please

Thanks in advance.

[tresesco]

If I have understood your requirement, try something like this:

Current Week Rev = Sum (If (Week(DateField)=$(vCurrWeek), AmountField)        , where vCurrWeek=Week(Max(YourDateField)

Prev. Year Same Week Rev = Sum (If (Week(DateField)=$(vCurrWeek) AND Year(DateField) = Year(Max(YourDateField) - 1, AmountField)  

The same logic can be implemented using Set Analysis.

Thanks.

[narender123]

Thanks  tresesko and er. Mohit.

Could you teel me how can i show date in dimention like

15 jane 16 june or can say 15/01/2013   16/06/2013 ..............

                                           sum(tax)     Sum(tax)  ................

Thanks u very much..

[narender123]

Thanks tresesko,

Prev. Year Same Week Rev = Sum (If (Week(DateField)=$(vCurrWeek) ANDYear(DateField) = Year(Max(YourDateField) - 1, AmountField)  is not working .I thing the problen is in bracks???

[tresesco]

Yes,

Year(Max(YourDateField)....... should be

Year(Max(YourDateField) )

[#8]

Hi Narender,

Don't use a calculated condition here. create a calendar table with the week field and use it in the application.       

[narender123]

Thanks Sampath . I have calculated it in my script but the problem is not regarding with it.

The problem is with previous year sum.