Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

BI Publisher: How to group by in data table

Received Response
62
Views
1
Comments
3023281
3023281 Rank 3 - Community Apprentice
in Oracle Analytics Forum

Summary

BI Publisher: How to group by in data table

Content

I have this data:

2017-05-19_152939.png

and I want to show the data like this:

2017-05-19_152949.png

but I insert data table using report editor, it shows as the following:

2017-05-19_153239.png

It doesn't summarize amount value.

Please suggest me.

Thanks in advance.

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    2017-05-22 09_09_04-Oracle BI Publisher.png

    Select your parent ... and set the grouping options as shown above ... if you want the summary row only, write your query to summarize before you visualize (then you aren't shipping the full volume of rows around).