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.