When I modify the excel cell in the excel report , the total field must change automatically, but it didn't work.
Question: When I modify the excel cell in the excel report , the total field must change automatically, but it didn't work.
Answer:
Export filter works from prepared report not from report template. That filter "does not know" what kind of data is in report cells, numbers itself or aggregate functions. You can modify exported report yourself, i.e. use SUM function for totals or any other expressions.