Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

CREATE REPORT WITH 3 LEVELS OF SUMMATIONS

Received Response
1
Views
1
Comments
Gor_Mahia
Gor_Mahia Rank 4 - Community Specialist
in Oracle Business Intelligence Applications Forum

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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.