Consolidate the amount in a separate page
Hi Team,
I am developing a report in Financial Reporting Studio and below are the details:
Row: Account
Columns: Accounting Period and Relative Member for Accounting Period
Pages: Company
I have 2 companies and the data is displayed in 2 pages. Now i need to sum the Total column in each page and should display as consolidated amount in the 3 rd page.
I couldn't figure out how to achieve this requirement.
Please share your thoughts.
Appreciate.