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

(Chris Jeal) #1

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) #2

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?

(Peter Dykstra (AppSheet)) #3

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

(Chris Jeal) #4

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

(Aleksi Alkio) #5

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

(Peter Dykstra (AppSheet)) #6

Ah, thanks @Aleksi_Alkio Translate

#7

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