I recently joined a company and I'm starting to work with "Oracle Business intelligence enterprise edition". With the "Oracle Business Intelligence 12.2.1.4.0" version to extract the info from the database. I have never worked with software like this...
The case is that I am making a query between two different areas.
One of them gives me numerical values, the other gives me labels from 3 different categories. The column that relates both areas is the ID.
That is, this ID has a label in one area and numerical values are associated with it in the other.
My question is, how can I add the numerical values based on the value of the category column? To represent it all, I've combined the numeric values with a column created with the SUM(0) function, and for the labels, with a column created as ''.
Obviously, this shows me two lines for each ID value, since you can't add strings...
In the result, I would like to ignore the ID column and for the query to show me only three lines, one from each category and the total sum of the numerical values of each of them...
I hope I have explained myself..., Thank you very much!