- Select the Pivot option in workbook
In Layout:
- Add the Account field to the Rows
- Add a Subsidiary field to the Columns
- Add the Amount to the Measures
- Click three dots icon next to the Amount field
- To show the amount in the consolidated level, select Apply Consolidated option.
- To show the amount in Base Currency, select Display Original option.
Result:
