3 Replies Latest reply: Jun 3, 2010 3:42 AM by EvgenyGin_J RSS

    how to get sum of sales of current and prior week, by clicking  current week?


      I have table with fields: opDate, salesAmount.

      i should get weekly salesAmount.

      that what i have done:

      i create a chart type straight table..than i added calculated dimension weekName(opDate) in this chart. Also i addded list box with the same parametr expression(weekName(opDate) ). ok

      when i click the list box item(weekName) i get sales per week in straight table chart. ok. this i've done.

      2. My second goal is to do second field in table, where i will get pror week sales. I added calc dimension: WeekName(opDate-7) - and it works - if i choose 28 week - in this dimencion i see 27 week. but the sum is 28 week - because i clickked on 28 week...

      How to do: i click 28 week - and get sum of sales of 28 week and 27 week and calculated deviation of currernt and prior week...