Oracle ICS - (problem with grouping lines with arithmatic logic)

Summary

Oracle ICS - (problem with grouping lines with arithmatic logic)

Content

I'm trying for the solution using ICS thereby i'm raising question.

Please find the use case as given below:

first we will apply the discount for each row as per the discountType.

if discount type is "amount" then we will do amount-discount or if discount type is "percentage" then we will do amount- (amount * %/100).

After this change, we need to merge the output lines as per the condition if (manufacturer and type) values are equal in the records.

ex: if (manufacturer = 'CISCO' and type='Network'), then we need to sum the amounts from the records.