0How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source.
Name the field in the Calculated field and apply the formula by Double-clicking on the field representing the numbers (available below).
Example :
Name: Price(in Mn)
Formula := 'Total price' / 10^6 ---> to covert into millions.
Now here comes the new field with Price(in Mn) in the pivot table. Now we can remove or add it later as per our requirement
