Chart using week as Dimension and shows current and previous week's data

[#1]

Hi I am trying to find out if this is possible. 

WeekStart	Count1	Previous Week	Count2
1/1/2012	10	12/25/2011	3
1/8/2012	15	1/1/2012	10
1/15/2012	21	1/8/2012	15
1/22/2012	5	1/15/2012	21
1/29/2012	3	1/22/2012	5
2/5/2012	11	1/29/2012	3

I have tried as following

Dimension: WeekStart

Count1 :

=sum(Count)

Previous Week:

=WeekStart(WeekStart, -1, -1)

Count2:

=sum({$<WeekStart={$(=WeekStart(WeekStart, -1, -1))}>} Count) // -> not working as is

Do you know if above table is possible?

Thanks,

Sean

[#2]

Hi Nouckduri,

  Try This Expression

    =SUM({$<WeekStart={$(=max(WeekStart),-1)}>}Count)

Regards,

Nirmal.

[#3]

Hi Nirmal,

I have tried it, but seems not working... 

=SUM({$<WeekStart={$(=max(WeekStart)-1)}>}Count)

[#4]

in between (weekstart) and -1 please asign comma(,)

[#5]

I have tried both.

[#6]

what's the error it shows

[#7]

I have attached my file.

It gives me 0.

[#8]

i think error in script....can you share your app with me

[#9]

i have added it in my original post.

[#10 · Accepted solution]

Try using above function. in the first column calculate Week's Sales.

In next use expression like =Above(column(1))  then if you are interested in only difference you can just hide these columns in presentation.

Regards