🔹 Values Area kya hota hai?

Pivot Table ke Values Area mein hum wo field rakhte hain jiska calculation karna hota hai.

For example, agar sales data hai:

Agar Sales field ko Values area mein drag karenge, Excel automatically usually Sum of Sales calculate karega.

🔢 Values mein Important Calculations

Pivot Table mein Value Field Settings ke through different calculations kiye ja sakte hain.

1. SUM – Total nikalna

SUM ka use numerical values ka total nikalne ke liye hota hai.

=SUM(B2:B10)

Example:

₹10,000 + ₹20,000 + ₹15,000 = ₹45,000

Pivot Table mein:

Values → Sum of Sales

2. AVERAGE – Average nikalna

AVERAGE ka use values ka average nikalne ke liye hota hai.

=AVERAGE(B2:B10)

Example:

Marks: 60, 70, 80

Average:

70

Pivot Table mein:

Values → Average of Marks

3. COUNT – Entries ki counting

COUNT numerical entries ki counting karta hai.

=COUNT(B2:B10)

Example:

Agar 10 students ke marks available hain, to COUNT result:

10

Pivot Table mein:

Values → Count of Marks

4. MAX – Highest Value

MAX range mein sabse badi value find karta hai.

=MAX(B2:B10)

Example:

Marks:

65, 78, 92, 84, 70

Highest Marks = 92

Pivot Table mein:

Values → Max of Marks

5. MIN – Lowest Value

MIN range mein sabse chhoti value find karta hai.

=MIN(B2:B10)

Example:

Marks:

65, 78, 92, 84, 70

Lowest Marks = 65

Pivot Table mein:

Values → Min of Marks

🛠️ Pivot Table mein Calculation Change Kaise Karein?

Agar Values area mein Sum of Sales aa raha hai aur aap Average chahte hain:

1. Pivot Table par click karein.
2. PivotTable Fields panel open karein.
3. Values area mein Sum of Sales par click karein.
4. Value Field Settings select karein.
5. Required calculation select karein:
   • Sum
   • Count
   • Average
   • Max
   • Min
6. OK par click karein.

Excel selected calculation ke according Pivot Table ko update kar dega.

📊 Ek hi Field par Multiple Calculations

Ek hi field ko Values area mein multiple times add karke different calculations bhi kiye ja sakte hain.

Example:

Rows → City

Values:
    Sum of Sales
    Average of Sales
    Max of Sales
    Min of Sales

Result:

👉 Isse ek hi report mein multiple types ka analysis ho jata hai.

🎓 Student Report Example

Student data:

Pivot Table:

Rows   → Course
Values → Average of Marks

Result:

Agar Max of Marks select karein:

💼 Practical Uses

Values calculation ka use:

• 📊 Sales ka total nikalne mein
• 🎓 Students ke average marks nikalne mein
• 👨‍💼 Employees ki salary analysis mein
• 📦 Inventory quantity analysis mein
• 💰 Financial reports mein
• 📈 Monthly sales comparison mein
• 🧾 Expense analysis mein