I have a matrix which is currently displaying sales data and I have drill through working from values within the matrix to a detail page. So, when I right click on a value in any column in the matrix, I get the ‘Drill through’ option appear in the popup menu from where I can select the required detail report - all works fine.
However, this doesn’t work when I right click on a grand total value at the very bottom of the matrix. I just get ‘Show as a table’ and ‘Copy’ options.
Is there a way of getting drill through to work from the grand total? I have a requirement to show the detail report for ALL data that makes up the report total.