Pivoting in Elasticsearch

[warkolm (Mark Walkom)]

You can do a table with an agg on NAME and then a sub-agg using a sum, on Code.
That'll look like this;

Not sure you can have it in the format you are after though.