I’m struggling to get the hours spent form my Epics’ child issues by Time context.
In Rows I have 3 dimensions:
- Issue – here I take a calculated member [Issue.Advanced Roadmaps].[Master Project]
- Advanced Roadmaps Epic
In Pages I have 3 dimensions:
- Logged by Team
- Project State
Total Hours Spent as Measure:
Sum( Descendants([Issue].CurrentHierarchyMember), [Issue].CurrentHierarchyMember.get('Hours spent') ) + nonzero(( [Measures].[Hours spent], [Issue Type].[Epic] ))
This actually returns me all Epic’s child issues hours + Epic’s hours. but if I put Time as Page filter and select any period, it does not change anything but for the Epic’s hours.
-All Master Project | UK | Epic A | 10
-All Master Project | UK | Epic B | 5
-Master Project A | UK | Epic A | 150
-Master Project B | UK | Epic B | 100
1. I wish I could have only:
-Master Project A | UK | Epic A | 160
-Master Project B | UK | Epic B | 105
2. Instead of showing the total time, I need to show the total time depending on the timeframe selected with Time in Pages.
Any help much appreciated, thank you!