Display Pivot Values in Million

[XLML]

How can I layout a pivot table so that the items in the Data Field display in millions?


ie 1,860,299 displays as 1.9

Thanks,
XLML

 

[GlennUK]

Do Field Settings/Number ... and do a custom number format of

#,##0.0,,

Note the 2 commas after the format - this scales the number down by a factor of a thousand for each comma.

 

[XLML]

Thank you. Worked great!