UrbanPro
true

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Pivot table - Transform numbers in calculated field

Phanitha P.
29 Jan 0 0

How 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

 

0 Dislike
Follow 1

Please Enter a comment

Submit

Other Lessons for You

Excel Conditional Formatting
In this video, learn about Conditional Formatting, Creating Conditional Formatting Rules, Use Conditional Formatting Presets, Managing & Removing Conditional Formatting.

Mukesh Chopra | 06/07/2021

0 0
0

Advanced Excel and VBA concept
In this video, learn about Advanced Excel: - Data Input and Hidden Features, - Worksheet Navigation, - Excel Formulas & Functions, - Data Cleaning and Formatting. VBA and its useful Built-in Functions,...

Nagadarshan | 06/07/2021

0 0
0

Vlookup in excel
Vlookup is a very useful formula in excel. Vlookup can be used in two ways Exact and approximate. We can find and fill in data with the help of Vlookup. The syntax of Vlookup is: Vlookup (Lookupvalue,...

Shilpa Jain | 25/03/2021

5 0
1

Cell Properties

Gagan G. | 03/02/2021

0 0
0

Multiple rows selections

Gagan G. | 03/02/2021

0 0
0

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
Sponsored
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

Book a Free Demo

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more