Is there any sample workbook you can share so that it will more easier for people to help?
Create top N Countries with parameter (optional).
Here i have added top N city
In that set will take parameter entered value cities as top and remaining as others.
create calc as
if [Top Cities] then 'Top Cities'
ELSE 'Developed' END
Drag this calc and drag city into row.
Now we will get top and developed cities as well.
Thanks I think this make sense,
But can I check if the formula can work this way ? I having error on the below though.
if [Top Cities] then [Top Cities]
ELSE [CountryGroup] END
[Top Cities] is a set.
[CountryGroup] is a group data (group into developed and developing)
I should have the countries with the top 15 volume listed.
The remaining are then group into Developed / Developing.
See below :
As data date might change, I need my report to be dynamic.