Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
CREATE REPORT WITH 3 LEVELS OF SUMMATIONS

Gor_Mahia
Rank 4 - Community Specialist
Hi,
I've a query as below and i want to create inner most sum of category, then summing of DEPT then finally the sum of STATES
SELECT CATEGORY,GROUP_MEMEBRS,WORK_TITLE,DUE_AMT, PERIOD_YEAR,DEPT,STATE_NAME FROM MASTER_T
USING bi publisher 11.x + ms word API to create the rtf file.
any suggestion on how to resolve this.
0
Answers
-
Posting multiple time isn't going to make it any better and is against the rules of the community. Nobody in here is paid to look after threads and reply, it's a community effort: if somebody has something to reply, they will, without reposting again the same thing.
0