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!
