Calculated Member that subtracts 2 other values

[robert stangl]

Hello Community 

I'm an Easzybi noob, so please bear with me..

I'm hoping someone can help with this.  We have a custom field dimension called PMO Projects for Project number filtering.  It has 3 main default entries of "Baseline", "All PMO Projects" &"non-project Discretionary".  Then the rest are all the separate Project number listings of which there are dozens.

What I'm trying to do is create a 4th default that would basically be ("All PMO Projects" minus "Baseline")

If i was to write this in SQL it would look like "PMO Projects" != PRJ*  (all the Projects start with PRJ).  But wildcards don't work on our Jira without certain plug ins. (also tried ?,!,~ with various syntax)

How would I write this as a calculated member using aggregation?  I tried this:

Aggregate(
{
[PMO Projects].[All PMO Projects] - [0002 : Baseline]

)
)

But then it tells me to create a calculated measure instead and when i try that it gives syntax errors.

Thanks in advance!

Rob