Skip to Main Content

complicated calculation

707781Oct 13 2009 — edited Oct 13 2009
here 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Nov 10 2009
Added on Oct 13 2009
2 comments
215 views