BEx: Select filter value - Combination search
I am looking for some expert advice here.
I have a simple BEx Query which display's long text and Revenue $ key figure information.
Is there a way to select the records based on combination search.
For example from the below dataset, I would like to select all the records which either contains PMO or Analytics.
|PMO - Project 1||100,000|
|Activity - PMO||200,000|
|Audit - Data analytics||150,000|
|PMO - Data Analytics||75,000|
|Big Data - Project 1||15,000|
|Big Data - POC||5,000|
We are currently on SAP BW 7.30 SP12 and use BEx Web reports. Any help would be highly appreciated.
Thanks and regards,