Create Lobby from saved search with grouping and sorting

If you are looking to add a Total Row to the bottom of Gross Amt/Base a Matrix Element would give you that option under the dropdown ‘Show Summary’ however it requires a Y Axis as well which isn’t required on the List element.
 

An alternative would be a combination of the List element that you have to display the breakdown per customer and then a Counter element to show the total next to it on the lobby.

Hopefully there is a better solution that someone much more knowledgeable than me can provide!

Regards
Nathan

svrmhuebner,

Your intention is great on the Customer Order Lines, but that is plain impossible with only the fields that are available. This is because you want it to show a combination of fields

round(sum(BUY_QTY_DUE * UNIT_PRICE_INCL_TAX), 2)

Either you prepare a new custom field that contains the calculation, which might proof difficult as there is a sum included and custom fields are per row.

Other way would be to prepare a quick report that shows what you want. But then comes my question, why the quick report if the results are the same in the Lobby element?

To me this boils down to the question: why would you want the same overview in the element as in the saved search of the Customer Order Lines?

Steve