Forum Discussion
Error: Members, tuples or sets must use the same hierarchies in the function.
I have a spreadsheet with multiple tabs all using a different tab (also in the workbook) as a data source. For some reason, when I apply filters to the pivot tables, and go to drill down into the...
CatGolez ,
That's an old issue, see, for example, discussion here https://blog.crossjoin.co.uk/2015/10/05/drillthrough-on-multiselect-now-works-in-excel-2016-and-ssas-2016/
Without playing with data model it's hard to say how to fix.
