Applied on total line the same calculation than on the other line for the calculated column

[filou711]

Hello Team,

Please find below a proposition of feature request:

Describe the feature:
We create a table visualization(like enhanced table in kibana) and create a calculated column.
We add a total line with an operator (like sum).
The total on calculated column, is not the one with the formula/calcul, but the total with the operator of total line.
We would like to have the same calculation on total line than on the other line of the calculated column

Describe a specific use case for the feature:
Imagine, we have these data:

• A list of data per country
• Country are aggregate in a column "COUNTRY GROUP"

I create an enhanced table to have the percent value between the two colum: Project margin/Indirect cost.
I add a total line with the operator "SUM".
I sum the value of Project margin/Indirect cost.
But on the calculated column, I have also a sum of all the value calculated.

I would like to have, on the total line, also the sum of the column Project margin/Indirect cost.
But on the column calculated, not the sum but the calcul between the two colum: Project margin/Indirect cost, like on this example (apply also on total line, the calculation):

Thanks for your feedback!

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[timductive]

Thank you for contributing to this issue, however, we are closing this issue due to inactivity as part of a backlog triage effort. If you believe this feature/bug should still be considered, please reopen with a comment.

[markov00]

Tracking request in Lens general improvements ice box #184459