Grouping a filter

[Anonymous]

Dear community,

A sales manager wants to filter a report based on the business units of his region. Some business units, however, are part of multiple regions. For simplicity reasons, I want to create 3 buttons on the top of my report: region A, region B, region C. 

When region A is selected, I want to filter the report on business unit A, B and C

When region B is selected, I want to filter the report on business unit A, D and E

When region C is selected, I want to filter the report on business unit A, F and G

Right now, I only have a filter in my report that includes all the business units. I hope I explained my problem enough.

Do you have any suggestion on how to achieve this goal?

[v-yuezhe-msft]

@Anonymous,

Could you please share sample data of your table?

Regards,
Lydia