kibana 4 - Pivoting in Elasticsearch -

can tell me there way in elasticsearch/kibana provide pivoting feature in oracle?

i want create report pivoting field sum aggregation.

for example : have schema indexed in test-index/test-type doc id being id.

id | name | code | amt ----------------------- 1  | abc  |    | 10 2  | def  |   c  | 20 3  | xyz  |    | 30 4  | abc  |    | 10 5  | abc  |   c  | 20 6  | xyz  |   b  | 30 7  | def  |   c  | 10 8  | def  |    | 20 

i want generate report pivoting done : sum(amt) code in (a,b,c)

name |  |  b  | c  --------------------- abc  | 20 |  0  | 20 def  | 20 |  0  | 30 xyz  | 30 | 30  | 0 

can using elasticsearch , reports generated in kibana? ps. new elasticsearch query dsl, helpful if having grasp on query dsl can me out whether possible in es , or suggest me way this??