To hide row in EazyBI, not removing

Questions & Answers
1

I have created a report using components and issues in row and calculated member in column.
I have applied filter on issue in which summary must MATCH “RUN Support” and generate a report.
Now i want to hide the issue and get report only for component and calculated members.

Is it possible ?

2

Hi,

You can create a new calculation to sum your measure for issues with the same conditions as you use in the report filter. The formula in your case would be the following:

Sum(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Issue].CurrentMember.Name MATCHES “.RUN Support.”
),
[Measures].[Some measure]
)

Now you can remove the filter condition and the Issue dimension from the report. The measure should show the total per component and the overall total.

Kindly,
Janis, eazyBI support