EPM Filtering conflicts with report with shared rows
I have an issue with EPM filtering. In my sheet there is a main report, on which filtering should be performed, and a secondary report, which has shared row axis with the main one. The problem is, when I switch on filtering in the main report, ALL data in secondary report disappears, even if those rows are not affected by filtering and still remain in layout.
Please share your opinions about this problem.