I am stumbling with this in a huge way and I'm hoping someone here can help. I have a SharePoint List that has two fields I want to collect data from. The first field in Location and the Second is Status.

I am looking for a way to show in possibly another list: Location Name - Number of Items Listed to that Location - Number of Items in Status 1 (specific to this location) , Number of Items in Status 2 (specific to this Location)

There are a number of different Locations but only 2 status options. I cannot use the excel webpart (not enabled in our company) to extract the data and show it that way so needing to find a workaround. I hope all the above makes sense!

Thanks in advance to anyone that might be able to help!

Deirdre