How can I show selective column data from multiple lists within a webpart on the homepage.Such that it shows the aggregate information for specific column data from multiple lists.
Environment: SharePoint 2013
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
If you need to show data from multiple list then there is no predefined direct WebPart available. But You can make use of Content Search WebPart in tricky way in order to achieve this functionality.
Its little bit tricky but it will definitely work because i already gone through this requirement.
This can be achieved using SharePoint Search Service Application. You can bind the search result from Search Service Application directly into Content Search WebPart.
Here is the best ever explanation for your problem. Lets have a look to this thread.
Let me know whether this solves your requirment or need some more.