summary data in Grid query for dynmic columns

[pranit@srcomsec]

We need the summary data in the grid but the column position cannot fix, I mean the dynamic column with different column index for any column in the grid.

As per your sample article below, here you set hardcode (revenues:'sum(C:C)'). We need to set "C:C" dynamically based on the column index. Please advise
https://paramquery.com/pro/demos/summary_json

[pranit@srcomsec]

Any update on this?

[paramvir]

you can get the letter corresponding to column index by pq.toLetter method:

https://paramquery.com/pro/api#method-toLetter

[pranit@srcomsec]

Thank you. Working great!!