This is a migrated thread and some comments may be shown as answers.

Group by and count

1 Answer 190 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
J Do
Top achievements
Rank 1
J Do asked on 12 Feb 2011, 06:26 AM
How can I count how many records per group by item.
ex:
group by Category         count Subcategory           
------------------------------------------------------------------
Category1                              2 (sub1,sub2)                                            
Category2                              3 (sub3,sub4,sub5)          

                                                   
Thanks

1 Answer, 1 is accepted

Sort by
0
J Do
Top achievements
Rank 1
answered on 12 Feb 2011, 10:06 PM
I got a solution

First, I row group with Category, then on the same row detail, I have an expression =Count(Fields.SubCategory)
Tags
General Discussions
Asked by
J Do
Top achievements
Rank 1
Answers by
J Do
Top achievements
Rank 1
Share this question
or