CODEWITHSUNDEEP
oracle-databaseplsqlgroup-byoracle-analytics
Andrew
Andrew

Reputation: 1

How to find the sum of each group which is grouped by another group?

I am actually trying to make a matrix table using Oracle Analytics tool and PL/SQL.

Let's say i have a query which has in select statement variables Employee, Description, orderid ,amount and is grouped by Employee, Description. Orderid and amount belong to the same group. From this query i want extract the sum of the amount of each description from all employees. Do you have any idea how i can do this?

Thank you.

Edit: Let's say we have the following query:

Select Employee, Description, orderid ,amount
  From Employees
 Group by Employee,Description

I want to extract the sum of amount from each Description group but from all Employees.A way to do this could be like this:

Select Description,sum(amount)
  From Employees
 Group by Description

But the actual query is much more complex and if i choose to make another query for finding the sum of each description i have to link it somehow to the first query to be able to show the results at the report. Do you have any idea of a way to do this through oracle analytics publisher?

Thank you.

Upvotes: 0

Views: 103

Answers (1)

vedataslan
vedataslan

Reputation: 1

Select coalesce(Employee,'ALL_EMPOYEES'), coalesce(Description,'ALL_DESCRIPTION'), orderid ,amount
  From Employees
 Group by ROLLUP (Employee,Description)


Select coalesce(Employee,'ALL_EMPOYEES'), coalesce(Description,'ALL_DESCRIPTION'), orderid ,amount
  From Employees
 Group by CUBE (Employee,Description)

Upvotes: 0

Related Questions