How to build a week-on-week report?

[#1]

I have a sales data by date, I want to produce a report Week-on-Week, so I can have the sales compare by week.

How can I produce this report?

Thank you!

[swuehl]

Just use Week (or Year and Week) as dimension in a chart and your Sales data in an aggregation function as expression:

=sum(Sales)

[#3]

I want to ge the compare data like the sales amount of year-week 31 vs year-week 30, increase, increase %...

like this:

outlets,sales of week 31, sales of week 30

outlet A, $120110, $97107

outlet B, $78130, $97236

outlet C, $98670, $119452

I want to have a sheet or a chart to display the week-on-week comparison.

How can I get this?

Thank you!

[shree909]

Hi i think u can create a listbox with  weeknumber on the followwing date filed

week (DATE)   AS WeekNumber

This can be done in 2 ways.

1) using Alternate states

2) create 2 variables    one with curent week and other with previousweek

vcurrentrweek = weeknumber

vpreviousnumver =weeknumber-1

then use the variabels in the set analysis  create 2 expressions  with outleet as dimension..

  for current week     sum({<Week = {'$(vcurrentweek)'}>}sales)

for previous week    sum({<Week = {'$(vpreviousweek)'}>}sales)

[rotero]

its easy to implement alternate state... less script