This is not possible to create pivot table in QS like you created in excel. But you can write calculated field and add that field in your pivot table. which eventually shows another column in table.
you can write calculated filed like this: ifelse(count(id) > 0 OR isNotNull(count({id})), 1 , 0)
add this in your table and change the total from default to sum.
2 Likes