OTBI - To Display Sum of a column based on other column in New Column

Summary

OTBI - To Display Sum of a column based on other column in New Column

Content

Hi,

I want to Display Sum of a column based on other column in New Column in OTBI Analysis . Is there any way to calculate just like Order BY in SQL . I don't see that in the Aggregate functions.

  I have data in column1 & column2 and i need to see the data in column3 based on those two columns in OTBI reports & analytics.

Column1    Column2  Column3

A                 100            1000

A                 200            1000

A                700             1000

B               500              800

B               300              800

C              150               150