WEBI Report - Exception aggregation..

Hi,

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

ConditionType Amount

XXXX 150

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.

Thanks,

Milind