colsum is not in scope, can you provide create table statements and provide some sample data and what the exprected results should be
This forum is for Sql Developer questions only.
Please mark the thread ANSWERED and repost in the Sql and Pl/Sql forum.
Before you repost REREAD your query carefully. There is NOTHING named COLSUM that is defined ANYWHERE in your query.