I have not seen an example of this, and if there is forgive me and please point me in that direction, but wanted to put it out there. Is there a way to have a running total in a calculated column? This would be where the calculated column adds the previous column amount so you can have a running total in the calculated column. Also would it work with grouping?
Any direction would be appreciated.
Appreciate your quick response, but I am not looking for the sum of the calculated column in a footer or header, but rather if there is a method to create the calculated running total column (aka Balance from original post example). Meaning how would one create a calculated column that grabs the Balance from the previous row (if it exist) and add it to the current row Amount + previous rows Balance.
If you check the post I’ve referred you will find details on how to perform calculations directly in the template of the column and display the result. If you need however to sort, filter and group this column you should create additional property for your data item where you can perform desired calculations in the property getter.
Thank you very much for opening my eyes. The approach is very clever with the child component.
Thanks very much @enchev