Hi experts,
In this example I select one country only [Country]='Sweden' and some customers belonging to this country [Customer]='BB', 'CC' . I get the expected measures in column 3-5 but for column 6 I can't figure out how to write the correct set expression. For this measures I want to include all Countries & Customer except Customers not selected under the selected country ('AA', 'DD') if there was a selection of customers.
Help on this would be highly appreciated. RGDS//Peter
| Country |
Customer |
{1}
sum(Sales)
|
{1 <Country={'$(=getfieldselections(Country))'}> }
sum(Sales)
|
{1 <Country={'$(=getfieldselections(Country))'}, Customer=$::Customer > }
sum(Sales) |
? |
| SA: |
- |
1700 |
700 |
500 |
1500 |
| Sweden |
AA |
150 |
150 |
- |
- |
| Sweden |
BB |
200 |
200 |
200 |
200 |
| Sweden |
CC |
300 |
300 |
300 |
300 |
| Sweden |
DD |
50 |
50 |
- |
- |
| Norway |
EE |
300 |
- |
- |
300 |
| Norway |
FF |
200 |
- |
- |
200 |
| Norway |
GG |
200 |
- |
- |
200 |
| Norway |
HH |
300 |
- |
- |
300 |
