I have a report with dynamic tables in Jaspersoft Studio, the problem is the following, my tables are visually only two, one for banks and one for totals, in the presentation, in the Banks rows are generated with the values, but the values are dynamically generated. Banks in the columns, in the same way, the values of the rows are generated in the presentation dynamically in the respective cells of the columns, the values in quantity corresponding to each Bank, then, at the end I place a field called total, this is shown at the end of the dynamic columns of the Banks, but when performing the sum, as in the visualization or design I have only two fields, in the presentation the total field is shown at the end of the dynamic Banks but not the total calculation of the sum of the cells, since this in the presentation is shown superimposed on the quantity values (that is, the value of the quantity is shown in the rows of the columns of each bank respectively, and the total is shown above it) each Bank, and at the end in the column rows the final total, how can I let the total text display the value of the sums of the rows at the end of the dynamic quantities? Also, the problem is that that total adds the accumulated quantities, and I just want it to show me the total result of the dynamic quantity, the Banks are dynamic horizontal, and the quantity rows vertical, but they are displayed dynamically horizontal with each bank.
