I want to have a dynamic formula for the excel sheet that is generated using JasperReports. The dynamic formula is should be able to identify the number of rows that is returned by the query and able to perform some customised function. I do not want to provide cell values in the formula. Rather the cell value need to be caculated on the number of returned rows. For example , if I need to find the sum total of a column (may be 100 rows currently)and on filter , if i have only 5 rows, then I want the formula applied only for that 5 rows. Please guide me.
Is this possible or it is yet to be implemented. Please let me know.