Grouping with SUM in footer

[Jon]

Hi,

I maybe doing something stupid or missing something here.

I've done a simple example 

Data coming in:

a 2 xwef
a 2 uybvu
a 2 guyvbfu
b 2.3 likubnil
b 2.3 lik43535
b 2.3 likub54543
b 2.3 gfwerg

With grouping based on first 2 values and the detail showing the 3rd value I want and get the following.
a      2
xwef
uybvu
guyvbfu

b 2.3 
likubnil
lik43535
likub54543
gfwerg

No I want to add a total at the bottom, I've done as SUM(2nd field)  the net result is 3 * 2 + 4 * 2.3,  It should be 2 + 2.,3

How should I get that?

Thanks for any help

Regards

Jon

[Petio Petkov]

Hi Jon,

You may create a custom aggregate function as described in the User Aggregate Functions help article.
Find attached a sample report similar to your scenario. The DistinctSum custom aggregate function is used in Report1 against the AdventureWorks database.

Hope this helps.

Kind regards,
Petio Petkov
the Telerik team

[Jon]

Many thanks Petio.  I managed to do it using the various data binding events.  I'll have a look at this for future work though,

Regards

Jon