I have the aggregate as shown above, I need a count of the underlaying items of the groups, any one an idea?
Roelof Jan wrote:
Hi Roelof,
right click on Id coumn and select count.
Seema Pandey wrote:
Thats is giving me a result of 45 for every group, but that is not what I need
Then probably there are 45 records in each group, because this will give exact count of records for each row.
use your aggregate count:
André Pinho wrote:
thats the total result of the groups, I need the amount of underlaying data records from each group. not the count of the total of groups
Can you explain your problem in more detail the terminology could be misleading,Do you want the count within each group? try the count method Seema explain but in non grouped attribute:
The columns in grey.
I realize this thread is quite old, but I think I am having the same problem. I have my data grouped by the element ID/Element Title. I want to know how many rows are within each element. I added the count column as suggested, and in the example data, it shows 6 items in each element. When I put an expression on my view and publish it shows the count all all the rows, regardless of element, so instead of 6 items in each one, it shows a total of 72. How can I get each line item to show just how many rows are in the group?