Currency Consolidation in Workbook
Currency consolidation in Workbook consolidates the values of a field to the currency of the lowest level subsidiary that is a common parent to all the subsidiaries that you have access to in your account. The rate type used for the consolidation is based on the general rate type set up for each account in your chart of accounts: either Historical, Average, or Current. This is the same as the Per-Account option used for exchange rate types 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 cannot choose the exact period or date to be used for the exchange rate. Instead, the rate is based on the date you run the workbook visualization that the field being consolidated is in. For more information, see Consolidated Exchange Rates.
In Workbook, you can only apply currency consolidation to amount fields from the transaction accounting line record type. Like with saved searches and reports, you can also only apply consolidation if you are in NetSuite OneWorld account with multiple subsidiaries. To ensure that the correct rates are applied during consolidation, make sure that your chart of accounts and consolidated exchange rates are set up correctly. You should also verify that your currency exchange rates are set up correctly since they are used in 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 apply currency consolidation in a dataset, you must create a custom formula field using the context value #currency_consolidated. For example, to consolidate the values of the amount net field from the transaction accounting line record type, use the following formula definition:
TO_NUMBER({transactionlines.accountingimpact.netamount#currency_consolidated})
Currency Consolidation from the User Interface
In workbook visualizations with amount fields from the transaction accounting line record type, currency consolidation is enabled by default. If you deactivate it, click the Field Menu icon 
next to a transaction accounting line field in the Layout Panel or column header, then point to Currency and click Apply Consolidation. If you are creating a calculated measure that includes fields with values in multiple currencies, you can also apply consolidation as part of the measure definition. For more information, see Calculated Measures.
In the Dataset Builder, the Filter window also includes a Consolidate field box for when you create criteria filters based on transaction accounting line amount fields.
When you check the Consolidate field box, the values of the field are consolidated before the selected filter conditions are applied. The rate type used for the consolidation is based on the general rate type set up for each account in your chart of accounts: either Historical, Average, or Current.
The Consolidate field box is only available for fields from the transaction accounting line record type. To create criteria filters based on converted values from other record types, you must first define a custom formula field that applies currency conversion to the field, then create your filter conditions based on the custom formula field. For more information, Currency Conversion Using Custom Formula Fields.