reports using Sharepoint Lists

• AntonyO

  Mr or Mrs. 500

  Points: 522

  More actions

  March 14, 2018 at 2:17 pm

  #329856

  Hi,
  I need to do a report using SharePoint lists as datasource.
   I use a List  (FactTable) with these Data as DataSource for a Matrix:
  
  But I have the necessity to show ALL the 8 Geographical Areas and all the 5 Subcategories, even if there are not existing in my FactTable. 

  
  .
  I have another 2 Lists Areas/Subactegories containing all the members (8 for Areas and 5 for Subcategories).
  Is it a way to do a kind of cross join (as in Sql Server) between more Lists ? Any other idea?

  Thks