Skip to Content
0
Former Member
May 13, 2013 at 03:19 PM

Grouping the summary at the footer by business type

16 Views

Dear Guru's,

I was wondering if there is a way to group the totals on the footer of a report by business type, Currently the report is outputing total values, but based on the overall value, not separated by business types.

Here is an example of the data on the table:

Business Type QTY Case Pallet M Internal 23 XX XX M Internal 23 XX XX M External 55 XX XX M External 55 XX XX

The output I want at the bottom of the report should look something like this:

Business Type QTY Case Pallet M Internal 46 XX XX M External 110 XX XX

The Current output just has the overall amount which is 156, I want to split it to look like the example up top.

Best Regards,

Matthew Ong