I am trying to get hours spent in transition status, just like pre-defined measures —[Measures].[Days in transition status].
Now I put the dimension Issues on Rows, and Transition status on Columns. And I put [Measures].[Hours spent] on Rows.
It seems working well, but not really . I have a four state workflow - Todo, Doing, Reviewing,Done, I created two issues and record hours in Todo and Reviewing. In the report, one issue report hours in Todo and Reviewing, the other report hours in Reviewing and Done.
Are there any hint about this? Thanks every much.