Aggregate Rows Based on Dimension Names

HeadyFinance — Mon, 26 Dec 2022 14:44:31 GMT

Hiya!

As the title says, I'd like to aggregate rows based on the name of a dimension.

See tables below for clarity.

So I'd like an output where every market that isn't the UK, US or DE to be in a aggregate Rest-of-world row.

So far I've tried

Aggr(if(Market<>["US","UK","DE"],Market),Market)

, but that didn't yield the above results unfortunately.

Thanks so much!

Re: Aggregate Rows Based on Dimension Names

rubenmarin — Mon, 26 Dec 2022 15:47:32 GMT

Hi, the syntax for that expression would be:

Aggr(If(not Match(Market,'US','UK','DE'), 'Rest-of-world',Market),Market)