I have done a little digging and the issue you are having with Mosha's solution (no drill through action showing in excel) is to do with getting the code exactly correct as discussed here: http://asstoredprocedures.codeplex.com/discussions/404064

You're right, as standard Drill through actions cannot use calculated members - the two solutions we have discussed are workarounds. 🙂