Question: how to calculate cumulative percentage in oracle?
Answer: SQL Cumulative Percent To Total The subquery SELECT SUM(Sales) FROM Total_Sales calculates the sum. We can then divide the running total, "SUM(a2. Sales)", by this sum to obtain the cumulative percent to total for each row.