How to Subtotal with multiple groups?

Question

Summary

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:

Thanks for your help.

John

John Bruso1 · Answer

Thanks Tim!

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

Whew!

John

timdexter · Answer

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