You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
507
Views
8
Comments
edited Dec 14, 2018 6:59PM in Reporting and Analytics for ERP 8 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!