I didn't make a sencha architect component for this but I have finally managed to implement the columns expand/collapse feature.
A drill down plugin could be easily implemented. Double click a cell in this example and you'll see how many records were used to aggregate that cell value: http://www.mzsolutions.eu/mzPivotGrid-configurator.html

Cheers,
Adrian