Currency Consolidation in Workbook
Currency consolidation in Workbook combines a field’s values into the currency of the lowest-level subsidiary that’s a common parent to all the subsidiaries you have access to. The rate type used for consolidation comes from the general rate type set up for each account in your chart of accounts: Historical, Average, or Current. This matches the Per-Account option for exchange rates in transaction saved searches. For more information, see Consolidated Exchange Rate Types for Transaction Searches.
In Workbook, if Current is selected for an account, you can’t pick the exact period or date for the exchange rate. The rate is based on when you run the workbook visualization that contains the field. For more information, see Consolidated Exchange Rates.
In Workbook, you can only use currency consolidation on amount fields from the transaction accounting line record type. Like saved searches and reports, you can only use consolidation if you're in a NetSuite OneWorld account with several subsidiaries. To make sure the right rates are used for consolidation, check that your chart of accounts and consolidated exchange rates are set up correctly. You should also check that your currency exchange rates are set up right, since they're part of some consolidated exchange rate calculations. For more information about currency exchange rates, see the Currency Exchange Rates List Page.
Currency Consolidation Using Custom Formula Fields
To use currency consolidation in a dataset, you’ll need to create a custom formula field using the context value #currency_consolidated. For example, to consolidate the amount net field from the transaction accounting line record type, use this formula:
TO_NUMBER({transactionlines.accountingimpact.netamount#currency_consolidated})
Currency Consolidation from the User Interface
In workbook visualizations, amount fields from the transaction accounting line record type have currency consolidation on by default. If you turn it off, you can turn it back on by clicking the Field Menu icon 
next to a transaction accounting line field in the Layout Panel or column header, then go to Currency and click Apply Consolidation. If you're creating a calculated measure that has fields with values in different currencies, you can apply consolidation in the measure definition too. For more information, see Calculated Measures.
In the Dataset Builder, the Filter window also has a Consolidate field box for when you make criteria filters based on transaction accounting line amount fields.
When you check the Consolidate field box, the field's values are consolidated before your filter conditions are applied. The consolidation rate type comes from the general rate type set for each account in your chart of accounts: Historical, Average, or Current.
The Consolidate field box only works with fields from the transaction accounting line record type. To make criteria filters based on converted values from other record types, you'll need to create a custom formula field that applies currency conversion, then build your filter conditions using that field. For more information, see Currency Conversion Using Custom Formula Fields.