A Creator form has currency input fields that are set as EUR.

When I create a pivot table with these fields, the data is displayed as $ instead of EUR.

Is there a way to make sure that the pivot follows the formatting that is set in the form instead of jumping back to (what I assume is) the default value?

The same applies to the formatting for aggregate formulas: these ignore the formatting for the fields in the formula and default to $ if you pick the currency datatype. How can I change this?

Thank you for your help.