TotalSummary of GroupSummaries in Devexpress

Question

2.50/5 (2 votes)

See more:

Hello
I have a ASPxGridview like this;
http://i.stack.imgur.com/9NZBa.png[^]
Is there any way calculate Total of GroupSummary to TotalSummary without Grouping.

GroupSummary's SummeryType="AVERAGE"
For Example;

MUS_K_ISIM   GroupSummary[RISK_EUR]
2M LOJİSTİK  123.456 
ABA LOJİSTIK 234.567

Then I want TotalSummary of RISK_EUR column is 123.456 + 234.567 = 358023
How can i do that?
Best Regards,
Soner

NOTE: I only want this calculation with normal Gridview. Not doing with Grouping.
EDIT: For example;

Customer_No Customer_Name Price
123         aaa           50
123         aaa           100
123         aaa           60
124         bbb           60
125         ccc           20
125         ccc           40

I want with that grid,
What is avarage of 123 number customer = 50 + 100 + 60 = 210/3= 70
What is avarage of 124 number customer = 60/1=60
What is avarage of 125 number customer = 20 + 40 = 60/2= 30
And then TotalSummary of Price is = 70 + 60 + 30 = 160

How can i do that? Or what is this code about? Which function should i use?

Posted 15-May-11 3:07am

Soner Gönül

Updated 15-May-11 3:18am

ambarishtv

v3

Add a Solution

Comments

Karthik. A 15-May-11 16:36pm

Best thing to do would be to approach devexpress support, they are extremely quick in responding to questions - http://www.devexpress.com/Support/Center/.

Soner Gönül 15-May-11 16:54pm

Quick, really? They are slower than turtle.

Karthik. A 15-May-11 20:47pm

Hmmm, that's surprising. I have been using their support forums for over a year. If you expect your questions to be answered in an hour, i don't think that's going to work.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik. A · Answer 1 · 2011-05-16T09:34:00

I read your question again. Why don't try this? For the ASPxSummaryItem w/in TotalSummary that has to display this, set it to custom, then handle the OnCustomColumnSummaryText event. Here get the ASPxGridView's data source and calculate the average's group wise and then overall average by using LINQ and then just set the summary text.

Hope this helps!