Hi,
I have created a report with the following headers:
Name; money in; money out
The report then totals the value of money in and money out at the bottom.
The format of the data in the name field is:
Fund1 class1; Fund1 class2; Fund2 class1; Fund2 class2
I would like the report to group data using the name field, however I would like the grouping to be based on just the Fund1 and Fund2 element of the name field so that the report and totals are split by Fund, rather than the individual Fund class (which is what currently happens if I try to group by name). I assume I will need to use an expression in the grouping options to achieve this, but I am not sure where to start!
Any help will be greatly appreciated!
I have created a report with the following headers:
Name; money in; money out
The report then totals the value of money in and money out at the bottom.
The format of the data in the name field is:
Fund1 class1; Fund1 class2; Fund2 class1; Fund2 class2
I would like the report to group data using the name field, however I would like the grouping to be based on just the Fund1 and Fund2 element of the name field so that the report and totals are split by Fund, rather than the individual Fund class (which is what currently happens if I try to group by name). I assume I will need to use an expression in the grouping options to achieve this, but I am not sure where to start!
Any help will be greatly appreciated!