Peoplesoft Kibana features

I have a business requirement where for a particular Account Tree / Department Treee Business wants to visualize a Kibana data table with aggregartion on amount spend across each Account level in different month buckets.

I would like to know as how this is posiible in Kibana Data table.

Levels Total Cost Jan Feb March April May June July Aug Sep Dec

----------------------------------------------------------------------------------------

Tree level(+) 204,222,891 Amt1 Amt2 Amt3 Amt4 Amt5

Please note (+) is expand the level to differnt tree nodes and corrospondingly see the monthly aggregated cost for each tree nodes. Attached expected Report layout