How can I increase the number of rows to more than 10000 in a table

I am using Grafana v9.2.0 for creating a dashboard in windows.My datasource type is elasticsearch and while creating a table panel in a dashboard it seems like I have limitation of 10000 rows which gives me wrong value at the end when I want to sum up the total cost. It was due to unable to load all data in the table and showing a total to only those that are displayed.

I want to increase my table rows to more than 10000. This is the screenshot for the section where I am changing the total rows displayed.

Hi @pratichhya,

Thanks for opening this post.

You can check this post as it explains a possible workaround on how to increase the limit:

I hope this helps.