In MS Excel 2004 this worked as expected, but in Excel 2011 it is very broken (puts the subtotals in the wrong order amongst other issues) and I would like to file a bug report as with Lion coming up ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results