complicated calculation
707781Oct 13 2009 — edited Oct 13 2009here is the case.
there are 2 dimensions and a fact.
2 dimensions: market and period
fact: profit
data in the database:
!http://img26.imageshack.us/img26/8099/datai.png!
on the dashboard , there is a prompt and a table.
the prompt defaultly selected a period, says period = 200905
my expected results:
!http://img26.imageshack.us/img26/2139/resulte.png!
how to achieve my goal ? do I need to modify RPD ? if needed, it is allowed.
thank you very much!