Hi Guys,

I'm new to pivot tables and looking for a little help or a point in the right direction.

I have a couple of columns with mixed data. for example:

Name Date Transaction Pol Type
John 01/05/15 NB PC
Bob 01/05/15 NB IBC
Sam 01/05/15 NB IC
Richard 01/05/15 NB IB
John 01/05/15 NB CV
John 01/05/15 NB CV


But I would like to create the pivot table to calculate certain criteria to one column, for example: anything with IBC, IC, IB add together so equalling 3

NB
Date Transaction Total Units
01/05/15 HH 3
01/05/15 PC 1
01/05/15 CV 1

Hope this makes sense.

Thanks!