I need to filter the assignees of a certain project in the page area.
In the page hierarchy I am using (in this order):
IssueType = Initiative
Assignee = All Assignee with Nonempty activated
But it does not filter only the assignees below this issue type.
Can you help me on how to filter assignee of a specific project by defining “Define calculated member formula” ?
In the latest eazyBI version 6.5. (and on Cloud), you can enable “nonempty” option in Pages as well, not only in Rows.
It does exactly that: if you select Issue type and Assignee dimensions (in that exact order) in Pages and select a value in the left dimension, e.g., Issue type, then the values in the dimensions to the right, e.g., Assignee, will display only relevant members (i.e. assignees which are assigned for this issue type). Read more: Create reports