I work for an organization that allows us to create SharePoint Sites / lists, etc. I have NO backend access to SharePoint, nor do I have access to SQL, SSRS, etc. I do have Access and Excel.
That said, my list in SharePoint is a list of "unique" projects. Each project has a choice field, with an option for multiple check box selections for "product". So - one to many. One Project may have 1 or MORE Products. I have been asked to generate graphical representation/report - using Excel - of the count of PRODUCTS in our PROJECTS.
When I export data to excel - and attempt to create a pivot table, each project has the PRODUCT lists sorted by a ;#. Which makes it impossible to get an aggregated count by product.
I have multiple fields like this - and hundreds of projects and products - so it's not conducive to manually break them all out - and I'll have to run the data on demand or at a minimum monthly.
IS there a way to process this through Excel with limited manual intervention to group / count the individual PRODUCTS?