Filter in EasyBI the Xray Test of the users who reported except one user

I need a Query/filter for EazyBI that will bring me the number of Xray Tests created except one user that I don’t want from the “Reporter” field for exampel Pablo XXXXXX

@zane.baranovska can you help me?

Hi, @Pablo_Andres_Cunarro

To filter out the Reporters you don’t want to see; please define the calculated member in the Reporter hierarchy using this formula:

Aggregate (
Except (
--All reporters
--except Pablo
[Reporter].[Pablo XXXXXX]

Then select this new member - not the “All Reporters”.

Kind regards,