Error using SUMMARIZE() to filter out rows

Hi quijote,

Thank you for the update. We appreciate the effort you’ve put into exploring different solutions and developing your own approach. We understand that unique scenarios like the "GLOBAL + Country" case often require customized logic, especially with complex filtering needs. While our suggestions may not have fully addressed your requirements, we are pleased to see you are testing your own workaround.

In parallel, we’ll revisit this scenario on our end to see if we can provide a more precise solution that meets your need to filter out redundant country rows when "GLOBAL" is present for an issue. 

If your custom approach works well, we’d appreciate it if you could share it with the community, as it may help others with similar data challenges.

Thank you.