Use calculated fields in a Google Sheets pivot table to count rows where a field equals a specific v-CodePudding

Home > database > Use calculated fields in a Google Sheets pivot table to count rows where a field equals a specific v

Use calculated fields in a Google Sheets pivot table to count rows where a field equals a specific v

Time：05-15

I have a sample sheet at

CodePudding user response：

I figured it out. I had to use countifs in the calculated field formula and then set summary to `custom.

CodePudding user response：

Try

={unique(B:B),arrayformula(IFERROR(VLOOKUP(unique(B:B),query(A:E,"select B, count(C) where D='Type 1' and E='Group 5' group by B"),2,0),0))}