There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Blank Rows in drillthrough Action report
I have a summary and detail table in my tabular cube joined on a key. The detailed table has a subset of the keys available in the summary table. I have created a drillthrough action which shows data from the detailed table.
On clicking the drillthrough action, I see blank rows in the report (for keys which are in summary but not in the detailed table). Is there a way to avoid getting blank rows in the drill through report?
See attachment for model, sample data and output.