How to set a formula for each column in the summary row

[hansot]

If you use table visualization during a dashboard, you can set a summary row at the bottom.
The summary row simply shows the sum or percentage of the corresponding column in the table,
Can you set this to a formula for each column?

For example, if you have a
The summary row for each column of 'sales', 'number of customers', and 'customer price' shows only the sum of the corresponding columns,
The summary line of 'customer price' is 'sales' / 'number of customers' = 7366600/951 = 7746.16 ... .

[elliotproebstel · Accepted solution]

You can achieve this by adding an appendpipe subsearch to the end of your current search:

your base search yielding the table above
| appendpipe 
[ | stats sum(sales) AS sales, stats sum("number of customers") AS "number of customers" 
  | eval "customer price"=sales/'number of customers' ]

[hansot]

thank you for your help!
i solved it.