Greetings
I have a question about grouping the rows and I couldn't find my answer in the docs
Consider I have a datasource with these columns : Name - Count
for example I have 10 rows of this data source and 4 of them have same Name and I want to merge their Count column and sum the count
like :
Test 1 | 20
---------------
Test 1 | 23
--------------
Test 2 | 12
and the result I want :
----------------
Test 1 |
| 42
Test 1 |
----------------
Test 2 | 12
*only the Count column is merged
Is it possible to do this?
Thank you.
Group rows by value of a column
-
- Posts: 7333
- Joined: Tue Mar 20, 2018 5:34 am
Re: Group rows by value of a column
Hello,
You can use the ProcessingDuplicates property.
https://www.stimulsoft.com/en/documenta ... icates.htm
Thank you.
You can use the ProcessingDuplicates property.
https://www.stimulsoft.com/en/documenta ... icates.htm
Thank you.
Re: Group rows by value of a column
Hi
The solution you provided merge the duplicate column and its different from what I want
Is it possible to merge and sum the value of other columns?
Like if column A is duplicate , I want to group them and merge column b and sum the value of it
Thank you.
The solution you provided merge the duplicate column and its different from what I want
Is it possible to merge and sum the value of other columns?
Like if column A is duplicate , I want to group them and merge column b and sum the value of it
Thank you.
-
- Posts: 7333
- Joined: Tue Mar 20, 2018 5:34 am
Re: Group rows by value of a column
Hello,
You can add grouping and Sum by groups.
Thank you.
You can add grouping and Sum by groups.
Thank you.
- Attachments
-
- Screenshot 2024-06-03 134108.png (39.59 KiB) Viewed 3652 times