Analytics Software

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!