Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

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
61
Views
1
Comments
3023281
3023281 Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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 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).