I'm new to WEBI and need help in figuring out how to achieve below reporting need.. We've below data set.
DocNo DocItem Material ConditionType Amount
1000 001 12345 XXXX 100
1000 001 12346 XXXX 100
1001 001 12345 XXXX 50
Report o/p should show
Same amount is always repeated for the different materials for the combination of DocNo, DocItem and ConditionType. Requirement is to calculate amount at condition type by considering amount only once ($100) for document 1000 and ($50) for document 1001.
Is it possible in WEBI?
Any help is greatly appreciated.