Output ?sub-aggregation? in a table

Hello,

back in forum with my questions after a very busy time ;-).

So my first question is: I want to output a table with different customers and different amounts. If the customer “changes” I want to output the sum of the amounts. At the end of the table I want to output the sum over all customers.

A little example:

Customer Order_number Ammount
Customer 1 123 100
Customer 1 125 50
Customer 1 130 30
Sum: 180
Customer 2 140 50
Customer 2 150 50
Sum: 100
Sum: 280

The only thing I know to realize is the total-sum at the end of the table with an aggregation-function. But how can I output the sum per customer?

Thanks for some answers!

Best regards

Timo

Find more posts tagged with

Comments

rtruban

Timo,

You should be able to do this by creating a 'group' in your table for customer. You can then create an aggregate that sums on the group and another aggregate that sums on the table.

Hope that helps,

Rob

iparker

Hello Rob,

Thanks for your answer! That is exactly what I’m looking for!

Best regards,

Timo