1.8 Customization

1.8 CUSTOMISATION

👇 Watch & share if you love this content!

🖥️ Check this out: Pivot Table - Customization

---

🔁 1.81 – Change “Count of” to “Sum of”

📊 Sometimes Pivot Table automatically shows Count of instead of Sum of, especially when data-ல் blanks இருக்கு.
✅ To change:
1️⃣ Right-click on the value
2️⃣ Click Summarize Values By ➡️ Sum
🎯 Use this to get accurate totals instead of counts.

---

🔢 1.82 – Number Formatting

🔍 Values readable-ஆ இருக்கணும்னா, proper number formatting must!
Steps:
🖱️ Right-click value ➡️ Number Format ➡️ Choose:

• Currency 💰

• Percentage %

• Comma style 1,000s

• Decimal places 🔟
  💡 Formatting improves professional look & avoids confusion.

---

🏷️ 1.83 – Field Name Formatting

🧾 Field names readable-ஆ, neat-ஆ இருக்கணும்:
➡️ Rename fields like "Sum of Sales" ➡️ "Total Sales"
Steps:
🖱️ Click on the cell with field name ➡️ Just type new name
📛 Avoid using same names as original fields – Excel won't accept duplicates.

---

🎯 1.84 – Predetermined Number Formatting

📐 Instead of formatting every time, set predefined formatting:
✅ Use Excel Table format before Pivot create பண்ணும்
➡️ Or, after creating Pivot, apply Number Format (as above) – it'll stick even after refresh.
🔁 Saves time & maintains consistency across updates!

---

🏷️ 1.85 – Change Sum Views in Label Areas

📊 Want to show summary like "Total", "Average", "Max", etc. in label area?
➡️ Right-click value field ➡️ Summarize Values By ➡️ Choose:

• Sum ➕

• Average 🔁

• Max 🔼

• Min 🔽
  🧠 Add more than one value field to compare different summaries together!

---

✅ These final steps make your Pivot Table cleaner, smarter & presentable 🔥
📈 Professional reporting = Better decision making!