I have the below scenario and need to address 2 requirementsSTATE VENDOR VENDOR NAME ROUTE S1 V1 ROUTE VENDOR R1 S2 V1 ROUTE VENDOR R1 R2 R3 S2 V2 O'BRIEN TRANSPORT SERVICES PTY LTD R4 S2 V3 Yorkie Bar Trucks R1
I need to display '*' in case of multiple route for a State - Vendor combination.Example screen shot as below:STATE VENDOR VENDOR NAME ROUTE S2 V1 ROUTE VENDOR *
Also need a separate report which will display only the details of multiple routes.Example screen shot as below:STATE VENDOR VENDOR NAME ROUTE S2 V1 ROUTE VENDOR R1 R2 R3
Please let me know if the above could be achieved in BEx Query???? If not is it possible in BO WebI report?