I am using SharePoint Online, I have site with several sub sites. each sub site has a list. All lists are using same content type. I need to rollup data from all sub sites. I dont want to use content search web part. I know that rollup can be achieved through content query web part and i can modify xslt to display multiple columns. But i want to display view in table format with sorting/filtering. Sorting and Filtering is Important.
Also please let me know if there is any other way to achieve rollup in SharePoint Online. I looked into some third part tools like lightningtools/bamboosolutions but these are very expensive.