Is it possible for a slice to count the filte...

[Chris_Jeal]

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?

[Chris_Jeal]

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?

[peterdykstra]

@Chris_Jeal1 try adding a second ‘Group By’ value (maybe the ‘Trailer No.’)

[Chris_Jeal]

@Peter Thanks, but on this occasion hasn’t worked.

[Aleksi_Alkio]

The easiest way could be a sheetformula… like QUERY expression.

[peterdykstra]

Ah, thanks @Aleksi_Alkio Translate

[Lynn]

Hi You can group by the Haulier twice , but I dont think you will see your totals… It is a requested feature though.