Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hiya!
As the title says, I'd like to aggregate rows based on the name of a dimension.
See tables below for clarity.
Current Output | |||
Market | Net Sales | Returns | Return Rate (%) |
US | 100 | 10 | 10% |
UK | 70 | 8 | 11% |
DE | 60 | 6 | 10% |
PT | 30 | 5 | 17% |
CK | 20 | 4 | 20% |
IT | 10 | 3 | 30% |
Desired Output | |||
Market | Net Sales | Returns | Return Rate (%) |
US | 100 | 10 | 10% |
UK | 70 | 8 | 11% |
DE | 60 | 6 | 10% |
Rest-of-world | 60 | 12 | 17% |
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!
Hi, the syntax for that expression would be:
Aggr(If(not Match(Market,'US','UK','DE'), 'Rest-of-world',Market),Market)