Subtotals for Grouped Values

[jkh...@umich.edu]

Hi all!

Does anyone have experience with creating subtotals with grouped values? I'm creating a report to review project spending, but some projects have multiple P/Gs. 

I've grouped the P/Gs, so that if there are two P/Gs for a project, a line for each P/G appears, but I'd like a subtotal for that group as a third line. Does that make sense? Hoping to set this up in Business Objects rather than having to adjust in Excel each time I run the report. Happy to share the report for more context.

Thanks in advance for your help!

Jen

[Srinivas Perumandla]

Hi Jen, 

You can send the report to my BO inbox:perumand and let me know the measure you want to sum based on what dimension/s.

Thanks,

Srinivas