Calculating total

[ccsimo16]

Hi

I have a spreadsheet which looks like

Supplier    Tier      Value     Rebate

A                1              100          1%

B                2            200          5%

C                1             50            1%

D                 2             300          2%

I can calculate each line with no problem by using

=sum (value) * sum(Rebate)

The problem comes when i want to total all rebate by Tier

Thanks

[marcus_sommer]

It would work without the outer-aggregation like:

aggr(sum(value) * sum(Rebate), Supplier, Tier)

whereby it might be useful to round and or format it or maybe to wrap it with a class-function like:

class(aggr(sum(value) * sum(Rebate), Supplier, Tier), 5)

- Marcus