Is it possible for a slice to count the filtered sections of a slice by group and only show the group name with the count?
So, if I have a list like:
Haulier
Trailer No. BTS
123 BTS
111 Arc
555 Eld
852
But could it be like:
Haulier
Count BTS
2 Arc
1 Eld
1
Hope that makes sense?
I think that I’ve figured this one out, but I wonder if anyone would know if I can remove the data in between the BOLD NAMES and just show the BOLD NAMES and their count?
@Chris_Jeal1 try adding a second ‘Group By’ value (maybe the ‘Trailer No.’)
@Peter Thanks, but on this occasion hasn’t worked.
The easiest way could be a sheetformula… like QUERY expression.
Ah, thanks @Aleksi_Alkio Translate
Hi You can group by the Haulier twice , but I dont think you will see your totals… It is a requested feature though.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |