I have a data table with full numbers. Now I want to create a Pivot table
with numbers in 000's.
So data table will have $1,000,000 but in Pivot table I want to show - $1,000.

Thanks in advance for your help.