I am facing one issue while filtering the data at BEx level.
Scenario: I have the data coming at report for all the Vehicle No. but report should display the data where for a Invoice Date, Vehicle No. is going to have more than one Ship to Party. i.e., Single Vehicle should have more than one delivery location.
From the below screenshot, only 12.08.2019 invoice date should display in the report as it is having multiple ship to party for a Vehicle (#).
I tried at BEX level by applying the exception Aggregation for a newly created CKF and setting the Summation and Reference Characteristic as Ship To Party but unable to get the results.