prior week selections?

[Anonymous]

Hi,

i have chart like   'transaction' is  the Dimension and  Finding sum(sales) in this expression i have used week

here my req is

when i click  on current week i want see the result for last week

when i select 3 week dates then i want see the result for prior to select last 3 weeks

in clear

for example

current week    last week

1/3/2015         29/12/2014   - if he select current week then he need to see result for past week

if he select any 3 weeks at a time i want see result for past 3 weeks of selections

[jagan]

Hi,

Attach sample file so that it would be easier to provide solution.

Regards,

jagan.

[mdmukramali]

Dear ,

Kindly find the attached file.

as you mentioned if one Week is selected it will show the Previous week Total.

if you select 2 then it will show last 2 Previous Weeks Total and vice verse.

I hope it will help you.

Thanks

Mukram

[Anonymous]

hi when i click on any week i want see sales for prior to that week

for ex:

6/1/2014

13/1/2014

when i click on 13/1/2014 i want see for only 6/1/2014  it means for only that one

.(excluding selections weeks)

if i select 3 weeks then i want sales for past 3 weeks to prior to that weeks

like this if i select 4 weeks i want see four week sales for prior to selection weeks

[jagan]

Hi,

Try this expression

=Sum({<Week = ,WeekDate={'>=$(=WeekStart(Min(WeekDate), -GetSelectedCount(Week)))<=$(=WeekEnd(Min(WeekDate), -1))'}>} SoldAmt)

Hope this helps you.

Regards,

Jagan.

[SunilChauhan]

weekstart(date)-7

will give start of previous week and Date(date-7) will give date of previous week

[mdmukramali]

Dear,

did you check my attached sample file?

I think it's full filling your requirement

Thanks,

Mukram.