Sum all rows of a column and filtered the report with a specific column value
I have two doubts about to create a report:
1) I have one column with different currencies, and I would like to show the total result (sum) of this column in an unic field of all of this column. How can I do it?
2) I would like to filter the result of the report selecting the values of a certain column dinamically.
Example: Values in the account name column: {Test1, Test2, Test3}
Dynamic filter: account name with this value. If I select the first one (Test1), the report should show only the accounts with Test1 in the account name field.