Create a column summary with drill-through to filtered data

Given a basic table T with N columns. I'd like to take a subset of columns from T and transpose them to rows. Then compute a summary value for each of these rows, and then drill-through to filter...