This project has moved and is read-only. For the latest updates, please go here.

Tabular Drill through on Grand Total

Jun 2, 2014 at 9:55 PM
All my tabular actions for drill throughs from excelw orks perfectly except on the grand total row.

so in excel if i have

Area1 100
Area2 200
Grand total 300

Right click and Additional action works on 100 and 200 but not on grand total row. I have 2 drill throguh definitions defined
Jun 2, 2014 at 10:09 PM
How are the drillthrough actions defined?
Jun 2, 2014 at 10:15 PM
Drill through Action , Target Type = Cells ,Target Measure Group ('table naem " , No Conditions , Drill through columns defined , Default is set to Yes for 1 and no for other ,
Invocation Interactive.

Thanks so much for quick reply

Double click part works. Right click and Additional Actions when i do it says No Actions. on the grand total row
Jun 3, 2014 at 3:23 AM
I can reproduce this behavior of actions not showing up on the grand total row in Multidimensional models in Excel 2013. I suppose this is by design or an Excel bug. It's not even running an MDSCHEMA_ACTIONS DISCOVER command. If this is a problem for you, I recommend reporting it to the Excel team via a support case.
Marked as answer by furmangg on 3/17/2015 at 5:45 PM