I use a calculated member to count and to display “how many times during selected Time dimension period issue has been transitioned to the status that is selected in Transition Status dimension”
([Measures].[Transitions from status], [Transition Status].[Analysis])
How can I count the same during an other time dimension period? I need to count that from next time ( [Time].CurrentMember.NextMember) and now().
The final usage is to have a report with:
Rows: Issue and Time (all members at level Week)
Columns: 2 measures:
- Number of transitions to “Analysis” status during the week
- Number of transitions to “Analysis” status during all weeks after the current one
Thanks in advance !