Skip to Main Content

Share your product feedback

Categories Reports
Created by Leigh Villalovos
Created on Sep 15, 2025

Maintain currency format when summing worksheet fields in pivot tables

What is the challenge?

If a pivot table is bringing in currency formatted fields, and "sum values" is selected for the table, then the currency formatting "$" is not included

What is the impact?

The context of this being a currency focused table is lost

Describe your idea

If all fields in a pivot table, even those from custom worksheets, are currency formatted, retain that currency formatting when using "sum values"

  • Attach files