Hi Experts,
I have the following issue. I am working on a report that contains both regional and country information in the same result set.
Country
Amount
Asia pacific
1000
China
500
Indonesia
250
Philippines
250
Europe
2000
France
750
Germany
1000
Poland
250
I would like to create 2 separate groupings that contain the overview of regions and the overview of countries by also taking the suppression into account of one of the countries.
Expected result:
Group1
Country
Amount
Asia pacific
1000
Europe
2000
Group2
Country
Amount
China
500
Indonesia
250
France
750
Germany
1000
Poland
250
Currently happening:
if trim({Country}) = "Philippines" Then true else false
Result:
Country
Amount
GH1
Asia pacific
1000
GH2
China
500
GH2
Indonesia
250
GH1
Europe
2000
GH2
France
750
GH2
Germany
1000
GH2
Poland
250
I am unable to split the data in 2 groupings. I hope you are able to provide some advice
Thank you, Kr-