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! Edited to add that I have created a list with the Area's and beside each I have a count related lookup field which gives me the total number of units - now I'm just looking for how to add the number of units in status 1 and status 2