Formatting a data field in a pivot table
We need to format the data fields in a pivot table as we create it.
I've trying:
FieldSettings fieldSettings = dataField.getFieldSettings();
NumberFormat nf = fieldSettings.getNumberFormat();
nf.setCustomFormat("#,###.##;;;");
dataField.setFieldSettings(fieldSettings);
But there resulting pivot table doesn't have any formatting applied.
Any ideas?
Thanks,
Joe
|