Aggregate by Project Category

I would like to aggregate multiple project categories to get a single output across all.
Screenshot 2024-01-26 at 10.55.27 AM

I’d like to include several categories. I can’t quite get the code to stop giving me errors. I struggle with writing these formulas any help would be greatly appreciated; thanks!

In the Project dimension, use the ‘define calculated member’ option to create your aggregated member.
It should look something like the example below

I’ve called it ‘My categories’ but you can give it a more appropriate name

Use the ‘Aggregagte’ function and list the different categories you wish to include as per the example (which just has two items)