Hello There i have a big table in excel 2010, with many columns and i am crating a pivot table to get high level numbers, out of which i need to group multiple columns in to a single field as below. I /could manage to group on a single column, but how do i do it using multiple columns as below. Let me know if you have any questions and many thanks in advance.

Table 1
Col1 Col2 Count
A x 1
A x 1
A y 1
B y 1
B x 1
C y 1
C x 1


Pivot Conditions
A+B+X Yes 5
C+y No 2