thank you Timo for your response
my point is how can make buttons to retrieve counts ,avg of column
to this we make method and connect button to this method so i need to learning about this (j2se) that help me to make code
is there misunderstanding to the subject please guide me to right way
my best regards
make buttons to retrieve counts ,avg of column
You use buttons to trigger actions. Counts, avg and other analytics are better done on the db using sql.
You can then use the table footer to display the values. Check out Andrejus Baranovskis Blog: Oracle Analytic Functions for Total and Average Calculation in ADF BC and How to &#8220;roll your own&#8221; sub-totals and totals in an ADF table [Part 2] | Function1
And Implementing a Total by Using a Groovy Expression should get you started.