Displaying distinct values in a column filtered on other column in SAP BO report


There are multiple ways to do this. First is by creating a variable like this:

Terms Count =Count([Terms Code]) in ([Sales #])

You have to add this variable to your report. It will display 1 for all Sales # 1000 and 2 for all Sales # 1001. You can apply a filter on Count > 1.

You can also do this using PREVIOUS() function as below:

Previous([Payment Terms Code]; ([Sales #];[Line #]))

Updated on: 10-Dec-2019

766 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements