Devexpress中的GroupSummary的总计摘要 [英] TotalSummary of GroupSummaries in Devexpress
问题描述
你好
我有一个像这样的ASPxGridview;
http://i.stack.imgur.com/9NZBa.png [
例如；
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
然后我希望RISK_EUR列的TotalSummary为123.456 + 234.567 = 358023
我该怎么办?
最好的问候，
Soner
注意:我只希望使用普通的Gridview进行此计算.不进行分组.
例如；
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.
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
我想要那个网格，
123个号码客户的平均人数= 50 + 100 + 60 = 210/3 = 70
什么是124位客户平均= 60/1 = 60
125个客户的平均人数= 20 + 40 = 60/2 = 30
然后价格的总和是= 70 + 60 + 30 = 160
我怎样才能做到这一点?或这段代码是关于什么的?我应该使用哪个功能?
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?
推荐答案
我再次阅读了您的问题.为什么不尝试这个呢?对于必须在TotalSummary中显示的ASPxSummaryItem，将其设置为custom，然后处理OnCustomColumnSummaryText事件.在这里获取ASPxGridView的数据源，并按LINQ计算分组平均值，然后计算总体平均值，然后仅设置摘要文本.
希望这会有所帮助！
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!
这篇关于Devexpress中的GroupSummary的总计摘要的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
