Pivot Table - Numeric Format

Top  Previous  Next  

The Pivot Table editor window Numeric Format tab allows you to specify the numeric format used to display numbers in the pivot table.


Follow the steps below to specify the numeric formats on your pivot table;


You can specify a different numeric format for each summary value in the pivot table. As such, you need to select which summary you are specifying the details for.



Next, select the maximum number of decimal places you want to show. If your values are currency values, select force trailing zeros.


Finally, if you require it, select a currency symbol (value that will be displayed before your numeric values). If the value you want is not in the list, select other and enter your desired value. You can also enter a number suffix, a string that will be displayed after numeric values.


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0