Add Total & Average at Bottom row of ListView And Filter based on criteria

Hi All,

I have created ListView but not sure how to add total & average at the bottom row of list view.
The total to be added starting from column 10 to 25 whilst The average from column 26 until the last column.

Then, I want to the list be filtered based on criteria in Combobox. The selected criteria must recalculate the Total & Average at the bottom row. Any assistance would be much Appreciated..

Please Login or Register  to view this content.

ListView.jpg


Here is my Attachment.