🔹 1. Pivot Table Sorting kya hai?

Jab Pivot Table mein bahut saari categories ya values hoti hain, to unhe proper order mein arrange karna Sorting kehlata hai.

Example:

Agar Sales ko Highest to Lowest sort karein:

👉 Ab highest sales sabse upar dikh rahi hai.

🔹 2. Ascending Sorting

Ascending order ka matlab hai:

Small → Large

Text ke case mein:

A → Z

Example:

Delhi
Nangloi
Pitampura
Rohini

Numbers:

₹45,000
₹60,000
₹80,000
₹95,000

Use:

• Lowest to highest sales
• A to Z names
• Smallest to largest marks

🔹 3. Descending Sorting

Descending order ka matlab hai:

Large → Small

Text ke case mein:

Z → A

Example:

Rohini
Pitampura
Nangloi
Delhi

Numbers:

₹95,000
₹80,000
₹60,000
₹45,000

Use:

• Highest sales identify karna
• Highest marks find karna
• Top-performing products dekhna

🔹 4. Pivot Table ko Value ke According Sort Karna

Pivot Table ki important feature ye hai ki aap category ke naam ke according hi nahi, balki values ke according bhi sorting kar sakte hain.

Example:

Agar Total Sales → Largest to Smallest sort karein:

👉 Isse quickly pata chal jata hai ki kaunsa product sabse zyada sales generate kar raha hai.

🛠️ Pivot Table mein Sorting kaise karein?

Method 1: Right Click

1. Pivot Table mein kisi item par Right Click karein.
2. Sort option select karein.
3. Choose karein:
   • Sort A to Z
   • Sort Z to A

Ya values ke liye:

• Sort Smallest to Largest
• Sort Largest to Smallest

Method 2: Sort Option

Pivot Table mein kisi Row/Column label ko select karein.

Home → Sort & Filter

Yahan se required sorting select ki ja sakti hai.

📌 5. Multiple-Level Analysis mein Sorting

Agar Pivot Table mein multiple Row Fields hain:

Rows:
    City
    Product

Values:
    Sales

To City ke andar Products ko sales ke according sort kiya ja sakta hai.

Example:

Isse har city ke andar products ka performance compare karna easy hota hai.

💼 Practical Example – Sales Analysis

Suppose ek company ke paas 5000 sales records hain.

Pivot Table:

Rows   → Salesperson
Values → Sum of Sales

Sorting ke baad:

Is report se management easily dekh sakti hai ki kis salesperson ki total sales kitni hai.

🎓 Student Marks Example

Rows   → Student Name
Values → Average of Marks

Descending sorting:

👉 Isse marks ko highest se lowest order mein analyze kiya ja sakta hai.

⭐ Pivot Table Sorting ke Benefits

• Large data ko organized banata hai
• Highest/lowest values easily identify hoti hain
• Comparison easy hota hai
• Top-performing products/students/employees identify kiye ja sakte hain
• Reports ko readable banata hai
• Data analysis fast aur simple hota hai