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