Good Morning,

I need help trying to create this report as I can not figure out the best method of doing this. Here is what I need the report to do. My report is a sorted list of technology assets by location name. In each sub summary I need to list the count of all different types of devices. The device types are a value list which has all the items such as “Desktop, Laptop, Firewall, Cellphone” in the list. How can I get the totals for each location of each of these devices to appear? 

Please see the image below for an idea of what I am talking about.

Thank you in advance for your help!

There are various ways to accomplish this but the one I use is something like this:   countTypes.fmp12.zip

Essentially a related table based on your location then looping thru the record found set and counting up each known type - you will have to add columns for each type of count your need.