Counting the no of Items per catrgory in Pivot Table

[howard]

I have a Fixed asset register which I have set up in Excel. I have summarised the data using a Pivout Table by category. I would like to add an extra field so as to count the number of assets per category

It would be appreciated if you could explain to me on how to dow this

Fixed Asset Pivot Table.xlsm
	A	B	C	D	E
1	CapitalCost	(All)
2
3		Values
4	RowLabels	Cost	WrittenDownValue	SumofWrittendownValueas%ofCost	CountofNoofAssetsperCategory
5	ComputerEquipment
6	CorporateSignage
7	FurnitureandFittings
8	Generator
9	OfficeEquipment
10	Plant&Machinery
11	GrandTotal
Sheet1

 

[cyrilbrd]

Hi,
Could you post a small sample of your raw data? Thanks.

 

[howard]

Hi,

Thanks for the reply. I managed to sort out the problem, but dragging one of the fields into the values section and changing it to count

 

[cyrilbrd]

cool, thought you did that already was thinking it was something to do with your raw data...