We have some 97 locations split across 7 different regions/organisations. Typically it is:
Whilst we can report on a given region or site, it becomes a case of manual manipulation of data in Excel for the whole organisation. We can do this by Text to Columns but it would be great if we could have the report already doing that.
For example, we have several projects and two sites within the same location but licesing for those is diffeent at each site.
What do other organisations do in this scenario?