How to create a formula to show total cost for what is showing within filtered costs on a data grid.

0
Thinking in terms of Excel ... How do you add a "formula" to calculate the total costs of what is showing on a filtered data grid.    When my user comes in and filters based upon a date range, I want it so that the total cost of what they are seeing on screen shows up at the bottom and says "Total Monthly Cost" for example. 
asked
2 answers
0

In Data Grid 1 you can aggregate columns in the column settings. This only works when you use an XPath as data source.

image.png

image.png

 

In Data grid 2 I don't see this option of aggregates

 

answered
0

Not sure of what you would put in the xpath to get this to sum up. 

answered