Pivot Table Count No of Items per Category

[Howardc]

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://windowssecrets.com/forums/sho...594#post859594

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?f=27&t=35521&p=276185#p276185
https://eileenslounge.com/viewtopic.php?p=276185#p276185
https://eileenslounge.com/viewtopic.php?p=276185#p276185
https://eileenslounge.com/viewtopic.php?p=276673#p276673
https://eileenslounge.com/viewtopic.php?p=276751#p276751
https://eileenslounge.com/viewtopic.php?p=276754#p276754
https://eileenslounge.com/viewtopic.php?f=30&t=35100&p=274367#p274367
https://eileenslounge.com/viewtopic.php?p=274368#p274368
https://eileenslounge.com/viewtopic.php?p=274370#p274370
https://eileenslounge.com/viewtopic.php?p=274578#p274578
https://eileenslounge.com/viewtopic.php?p=274577#p274577
https://eileenslounge.com/viewtopic.php?p=274474#p274474
https://eileenslounge.com/viewtopic.php?p=274579#p274579
https://www.excelfox.com/forum/showthread.php/261-Scrolling-Marquee-text-on-Userform?p=864&viewfull=1#post864
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[Excel Fox]

You should be able to get the count of items simply by taking the count of any of the other fields that you haven't actually used in the pivot. Asset number, description, asset template or even purchase date can be used as count field.

[Howardc]

Thanks for the help, much appreciated

Are there any good tutorials you can recommend on Pivot tables. I have recently started using them and would like to learn more