How to Subtotal with multiple groups? — Oracle Analytics

Oracle Analytics Cloud and Server

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

How to Subtotal with multiple groups?

Received Response
32
Views
2
Comments

Summary

How to Subtotal with multiple groups?

Content

Hi All,

I'm still pretty new to BIP. I am struggling to understand how to achieve this subtotal grouping when I can not use nested groups.

How can I make the attached BIP report group and sort like this example, ordered by (A.WYO_CONST_DRFT_YR, A.WYO_TRANS_DISTRICT) and subtotaled by Year:

example.PNG

Thanks for your help.

John

Answers

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Thanks Tim!

    Just the hint I needed to make progress... I think I'm good now.

    Whew!

    John

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Hi John

    Welcome to the world of BIP.

    What you are asking for is a group left total. Check the docs and examples for the RTF template for more help.

    I dont have time this morning to look at your template but will later today.

    Regards

    Tim