Get summarized values based on fields. (count empty and non-empty values)

Hello ,

My task is to summarize a field depending upon 2 primary key fields and 4 secondary fields.

e.g. 1 aa bc bb 'X'

1 aa bc bd ''

1 aa bc bb 'X'

desired o/p is

1 aa bc bb 2 0

1 aa bc bd 0 1

exactly to count the non-empty and empty fields depending on 2 primary and 4 secondary fields.