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...