showing Weekly collection

[narender123]

Hi All,

Give me some idea.

I have attached 2 screen shot.In 1st screen shot, shows  this year current week collection and previous year current week collection which are running good for this year as well as for previous year.

But the problem starts when i select month and date of this month or another month,then it shows the collection only for that day of that month but i want for that day weekly collection with weekly dates.I have shown the problem in my 2nd print screen shot.In 2nd screen shot i have selected there

Year=2012 month=jan day=11

then it should show the week of 11jan2012 collection but it is showing only 11jan2012 collection means 12,13 ,14 ... are not there.I want that also..

I thing their is something wrong in my expression .

Thanks in advance.

Narender

[jagan]

Hi Narendar,

Try excluding the Day selection, by giving Day= in your expression

For example:

Sum({<Year={Some Value}, Month={Some Value}, Day=>} Sales)

Hope this helps you.

Regards,

Jagan.

[narender123]

Thanks Jagan.Its working.

Could you tell me something more about it.

if i add both expression(prevoius & current year) in single chart then result looks like as i shown in my attachment.

In attachemnt file it shows the prevoius year collection for previous year week day where current year shows 0 collection after prevoius year its start the current year week day collection where previous year week day collection shows 0.So what i have to do for this ???

Thanks

[narender123]

By frezzing Day like "Day=" .Its not effect for that chart.But here in chart is effecting after freezzing it.How ?

Please tell me??

Because i heard that after freezing any filter ,filter will not effect that chart.

Thanks.

[jagan]

Hi,

By giving Day=, in your expression it excludes the selection of the Day dimension.  We need to exclude because we need to override the selection to show current and previous year week data.

Regards,

Jagan.

[jagan]

Hi,

Combine 2 expressions into one expression, then you will get chart correctly.

Regards,

Jagan.

[narender123]

Thank you Jagan .

Is it possible to show my report looks like this

WEEKLY REVENUE COLLECTION
14th June	15th June	16th June	17th June	18th June	19th June	20th June
$339,252.03	$23,105.21	$149.14	$506,502.98	$511,347.33	$609,520.75	$766,880.61
TOTAL REVENUE COLLECTION						$2,756,758.05
TOTAL REVENUE COLLECTION 2012						$2,064,304.95

As i have made my report shown in attacment and i nt my report to look like above table.

Thanks.

[jagan]

Hi,

It is not possible in a single chart, below the chart, use labels or straight tables to display Total revenue calculation.

Hope this helps you.

Regards,

Jagan.