Hi Andrew,
From a consolidated total to the first levels that show the individual accounts and departments and I believe it goes to the indididual periods for a specific account as well - but no, not to a transaction level.
It was more of an observation than the drill down did not work in cells with that type of formulae and that it could possibly be a drawback in some instances than the fact that it was a drawback in that particular instance.
Thanks, Pete