To count the numbers of raws that are grouped…
Hi,
When we are on normal display (without groups) we can see a number in front of each row but they disapear in group display
Is there a way to count the numbers of raws that are grouped ?
Thanks
7 replies
-
Yes - if you men a count fro each records that sits under each group
so in this quick example
The Group has been set is set on Job Header
Expand it to show the records underneath it then on one of the columns (i've just chosen Qty here - click the header and select count)
Mel
-
Thanks Mel.
How do you use ”count” ?
Where do you find it ?
-
I create a field number and I tried in the head of the column : total sum min max first but it does not work…
-
I think ”Count” in the french version is ”Total” (in the filter box of the head of the column)
-
With Count (Total) I got #0 in all the columns…
-
Okay - List not gruped or with a count on
i then want grouped on custid
so I click its header and select grouped - which gave me this
now i click the > to show the lines
and select another heading - lets say Qty for example and click count
and result is ....
so first group has 15 records nd has 16 records etc
i've done this in seperate stages but you coud do it all as one process.
ie select Custid - click group - select qty click count
I'm on cloud version (not sure if that makes a difference)
-
Ok. Thanks a lot Mel.
And now if I would count the number of the groups (not the raws that are inside, but only the groups)
EG in your screen shot : they are 8 custids grouped
Content aside
- 3 yrs agoLast active
- 7Replies
- 386Views