Report Sum & Filter

[Domearian]

How can I sum the number when filtering on a pdf document. I was trying to use:

<<SUM(Filter(Wincanton Stats This Week[Persons Onsite]),[Location]=”WA248”)>>

Where it filters this week and sums the number of people at "WA248". The Wincanton Stats This Week[Persons Onsite] already performs the filter. Could I just use a simple AND instead of filter?

[Metworks_IT1]

Hi, try

<<Count(Select(Wincanton Stats This Week[Persons Onsite],[Location]=”WA248”))>>

https://support.google.com/appsheet/answer/10107676?hl=en&sjid=1296755179197474451-EU

[Metworks_IT1]

I might have misunderstood the question, try with SUM instead of count

<<SUM(Select(Wincanton Stats This Week[Persons Onsite],[Location]=”WA248”))>>

https://support.google.com/appsheet/answer/10107699?hl=en&sjid=1296755179197474451-EU

[Domearian]

That counts the number of submissions. What if a submission has the number of people as 23. It only responds with 1.

[Domearian]

I've managed to find the solution. Thank you.