How to create this table report in kibana according to this use case

I have fields items.displayName, items.instructions, itemCount (quantity), and fulfillmentDate in my Elasticsearch index. I want to create a table with the following specifications:

so i want to create table like this

Image 1

Image 2

Requirements:

point 1: item with instruction below that as we can see in 1 in table and breakdown sum(itemCount) by day and in last coloumn we have sum of overall(itemCOunt) of that item

point 4 : Base product should be displayed in bold with total count in column two+, then all product + instruction variants listed below.

Here's what I've done so far: I concatenated the instructions with the item display name in a new field to display the instructions below the item Name .

here is screenshot of that

image 3

but i am not sure about point 1(total) in image 3 that we need add sum(ItemCount) means Total in end of the row as column of that particualr item how can i do that and in last the how to point 2 showin in image 2

kibana lens #table #kibana-lens

Hi @kishorkumar

that is currently not possible.
I've open a feature request issue you can track here: [Lens] Datatable: provide summary column · Issue #182400 · elastic/kibana · GitHub