3 Show Value As

3. VALUE FIELD SETTINGS > SHOW VALUE AS

Excel Pivot Table 💻-ல இருக்குற "Show Values As" என்பது ஒரு magic box மாதிரி! 🧙‍♂️
நம்ம raw data-ஐ visually powerful and insightful format-ஆ convert பண்ண இந்த options ரொம்பவே useful 🤩.

👇 Watch & share if you love this content!

🖥️ Check this out: Pivot Table - Show Value As

---

🔢 3.1 - % of Grand Total

🗣️ என்ன? – Whole report-இல் இருந்து ஒரு value எவ்வளவு percentage?
📍 Example: Chennai sales ₹20,000, Total ₹2,00,000 → Chennai = 10%
✅ Use this when you want to find total contribution of an item.
📌 “Total India sales-ல் Chennai எவ்வளவு contribute பண்ணுது?”

---

📊 3.2 - % of Column Total

🗣️ என்ன? – Column-ல் உள்ள total-க்கு percentage.
📍 Example: Q1 Total ₹50,000 → Chennai Q1 ₹10,000 = 20%
✅ Use this to compare within same column (like months, quarters).
📌 “January month-ல் Chennai-ன் sales என்ன %?”

---

📈 3.3 - % of Row Total

🗣️ என்ன? – Row-ல் உள்ள total-க்கு %
📍 Example: Product A Total ₹25,000 → Chennai ₹5,000 = 20%
✅ Use this to compare across regions/products in same row.
📌 “இந்த Product-ல Chennai எவ்வளவு sales பண்ணிருக்கு?”

---

🎯 3.4 - % Of (Custom Base)

🗣️ என்ன? – You set a base value manually.
📍 Example: Chennai ₹5,000 vs Mumbai ₹10,000 → Chennai = 50%
✅ Compare anything with your chosen reference.
📌 “Mumbai-ஐ base-ஆ வைத்துப் பார்த்தா Chennai-ன் share என்ன?”

---

🏘️ 3.5 - % of Parent Row Total

🗣️ என்ன? – Hierarchy-ல parent row-க்கு base-ஆ வைத்த percentage.
📍 Example: Electronics ₹1,00,000 → Phones ₹25,000 = 25%
✅ Useful when working with category & sub-category.
📌 “Electronics category-ல Phones எவ்வளவு important?”

---

🧱 3.6 - % of Parent Column Total

🗣️ என்ன? – Column-based hierarchy-ல் parent-க்கு %
📍 Example: South India Q1 total ₹50,000 → Chennai ₹20,000 = 40%
✅ Use this to analyze performance inside grouped columns.
📌 “Chennai-னோட Q1 performance within South India?”

---

🌐 3.7 - % of Parent Total

🗣️ என்ன? – Row + Column இரண்டுக்கும் parent-க்கு %
📍 Example: Chennai-Phones ₹10,000, All Electronics-India ₹1L → 10%
✅ Good for complex reports with category + time combo.
📌 “Phones in Chennai contribute how much to total Electronics?”

---

➖ 3.8 - Difference From

🗣️ என்ன? – Difference (addition/subtraction) from base.
📍 Example: Feb ₹30,000 - Jan ₹20,000 = ₹10,000 increase
✅ Track month-on-month or year-on-year growth.
📌 “Feb month-ல் Jan-ஐவிட எவ்வளவு more?”

---

📉 3.9 - % Difference From

🗣️ என்ன? – % increase or decrease from base.
📍 Example: Jan ₹20K, Feb ₹30K → 50% increase
✅ See growth trend in % terms.
📌 “Sales 50% growth from last month!”

---

🧾 3.10 - Running Total in

🗣️ என்ன? – Accumulated total (like Year-to-Date).
📍 Example: Jan ₹5K + Feb ₹10K → Feb Running Total = ₹15K
✅ Track cumulative sales, revenue, etc.
📌 “So far sales எவ்வளவு நடந்திருக்கு?”

---

📊 3.11 - % Running Total in

🗣️ என்ன? – Running total but in % form.
📍 Example: Target ₹1L, Jan ₹10K → 10%, Feb ₹20K → 30%
✅ Track how much % of target is reached.
📌 “Quarter-க்கு 30% complete ஆகிவிட்டது!”

---

🥈 3.12. Rank Smallest to Largest

🗣️ என்ன? – Lowest value gets Rank 1
📍 Example: ₹5K = Rank 1, ₹10K = Rank 2
✅ Find poor performers easily.
📌 “Who sold the least?”

---

🥇 3.13 - Rank Largest to Smallest

🗣️ என்ன? – Highest gets Rank 1
📍 Example: ₹30K = Rank 1, ₹10K = Rank 3
✅ Find your top sellers instantly.
📌 “Top performer யார்?”

---

🧠 3.14 - Index

🗣️ என்ன? – Value’s relative strength across total data.
📍 Example: Index >100 = Over-performer
✅ Great for spotting standout performers across mixed categories.
📌 “Chennai-ன் Index = 130 → Above average performance!”

---

⚡ 3.15 - Shortcuts to Use Show Values As

• ✅ Right-click Pivot Table → Show Values As

• ✅ OR: Go to PivotTable Analyze Tab → Choose option

• ✅ Excel will auto-update instantly

🧑‍🏫 No formulas needed. Just a few clicks.

---

🏁 Final Recap 📝

Option	Use Case	Emoji
% of Grand Total	Overall contribution	🔢
% of Column Total	Compare in column (eg: by month)	📊
% of Row Total	Compare in row (eg: by category)	📈
% Of	Custom base item	🎯
% of Parent Row Total	Inside categories (row)	🏘️
% of Parent Column Total	Inside categories (column)	🧱
% of Parent Total	Full parent hierarchy	🌐
Difference From	Show difference in value	➖
% Difference From	Show difference in %	📉
Running Total in	Cumulative values	🧾
% Running Total	Cumulative %	📊
Rank (Small to Large)	Rank low to high	🥈
Rank (Large to Small)	Rank high to low	🥇
Index	Power metric across total	🧠

🔚 Summary (சுருக்கமாக)

Excelல இந்த Show Values As options-ஐ use பண்ணினா, raw data-வை super meaningful insights-ஆ மாற்றலாம். Sales, Targets, Growth, Comparison எல்லாத்துக்குமே இது 🔑 key!