Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
naseer78
Posted - 09/30/2009 : 23:25:36 I have developed dashboard contains two reports
Fist report shows current month revenue Second report shows previous month reveune
The requirment is: When I apply filter of time dimension on whole dashboard. The first report show show the current month as of Filter month value and the other report should show the previous months filter value.
Thanks in advance
1 L A T E S T R E P L I E S (Newest First)
admin
Posted - 10/01/2009 : 00:41:46 The "previous month" report needs to have a calculated measure with this kind of formula:
([Measures].[Revenue], [My Time Dimension].[My Hierarchy].PrevMember)
Assuming that [My Time Dimension].[My Hierarchy] is in the filters.