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

**URL:** <https://discuss.elastic.co/t/how-to-create-this-table-report-in-kibana-according-to-this-use-case/358652>\
**Category:** Kibana\
**Tags:** lens\
**Created:** [May 2, 2024, 1:55pm UTC](https://discuss.elastic.co/t/how-to-create-this-table-report-in-kibana-according-to-this-use-case/358652 "2024-05-02T13:55:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kishorkumar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kishorkumar/32/132930_2.png) [@kishorkumar](https://discuss.elastic.co/u/kishorkumar)\
**Post date:** [May 2, 2024, 1:55pm UTC](https://discuss.elastic.co/t/how-to-create-this-table-report-in-kibana-according-to-this-use-case/358652/1 "2024-05-02T13:55:07Z")

</div>

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](https://us1.discourse-cdn.com/elastic/original/3X/4/2/4209580f1731f576e88a8ac9dc21e4ecd65b9bbb.png)

Image 2

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/7/d763c4e84416acd7225509b193b513a5ced06c63.png)

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

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/1/f10e1fb975e65f67d7a18c699d3f4a3eba4fed1d.png)

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

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [May 2, 2024, 3:41pm UTC](https://discuss.elastic.co/t/how-to-create-this-table-report-in-kibana-according-to-this-use-case/358652/2 "2024-05-02T15:41:01Z")

</div>

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](https://github.com/elastic/kibana/issues/182400)