Hi,
I have a pivot table that feeds from a large table of data on a neighbouring
sheet and have grouped rows by contents of particular columns by dropping
several column headers into the row data section.

I am now trying to obtain sub totals of how many of a particular group are
under each heading for example...how many advisory clients or discretionary
clients are there? Answer being 2 and 3.

Client Name Stock Name Cleint Type Stock Value
A Smith BP Advisory £2000
A Smith Shell Advisory £3000
A Smith RBS Advisory £2000
A Smith HSBC Advisory £3000
B Smith BP Advisory £5000
B Smith HSBC Advisory £2000
C Smith BP Discretionary £7000
C Smith BP Discretionary £2000