I have a report where I sum the issues of type Defect based on the Selected Pages elements.
The purpose of this report is to provide a dynamic view on the total number of issues of type Defect for a selected period.
So if user selects Current Month, he will see the current Month number and previous Month number
Getting the current month is working well with following
Sum(
CrossJoin(
{[Issue Type].[Defect]},
{[Time].CurrentHierarchyMember}
)
)
When trying to reuse the same formula to get the number of the PrevMember I received an error stating there are no members.
Sum(
CrossJoin(
{[Issue Type].[Defect]},
{[Time].CurrentHierarchyMember.PrevMember}
)
)
How can I therefore get the total number of issue type defects for the same period -1?