Pivot Table Count No of Items per Category

Topic

New Reply

I have set up a Pivout Table which summarises the different classes of Asset Types

I would like to set up an addition column to count the number of items per category. It would be appreciated if someone can assist me and explain in simple steps how to set this up

Also are there any good Pivot Table tutorials available online that can be recommended that will assist with learning more about Pivot Tables

Your assistance regarding the above will be most appreciated

http://www.excelfox.com/forum/f22/pivot-table-count-no-items-per-category-460/#post1784

Reply | Quote

Replies

HowardC,

I dragged the Description field down to the Values area and it defaulted to count. Hopefully this is what you wanted.

Reply | Quote

Hi Maria

Thanks very much, this is exactly what i was looking for

Are there any Pivot table tutorials you can recommend?

Regards

Howard

Reply | Quote

Howard,

Here is a link to some Microsoft help for pivot tables.

http://office.microsoft.com/en-au/excel-help/results.aspx?filter=1&ck=1&av=zxl120&qu=Pivot Tables&ex=2

Regards,
Maria

Reply | Quote

Hi Maria

Thanks for the info much apreciated

regards

Howard

Reply | Quote