2 Value Field Settings

2. VALUE FIELD SETTINGS > SUMMARIZE VALUES BY

👇 Watch & share if you love this content!

🖥️ Check this out: Pivot Table - Summarize Values

---

🔁 2.1 – Create Multiple Subtotals

📊 One field-க்கு multiple summaries வேணுமா?
➡️ Drag the same field 2 or 3 times into the Values area.
🎯 Example: Show Sum, Average, Max for "Sales" — all in one table!

---

🔢 2.2 – Count

📦 Items count பண்ண:
➡️ Right-click any value ➡️ Summarize Values By ➡️ Count
💡 Example: How many orders per product?

---

➗ 2.3 – Average

🧮 Find average:
➡️ Right-click ➡️ Summarize Values By ➡️ Average
💡 Example: Average sale per region.

---

🔼 2.4 – Maximum

📈 Highest value கண்டுபிடிக்க:
➡️ Right-click ➡️ Summarize Values By ➡️ Max
💡 Example: Top-performing branch.

---

🔽 2.5 – Minimum

📉 Lowest value கண்டுபிடிக்க:
➡️ Right-click ➡️ Summarize Values By ➡️ Min
💡 Example: Lowest sale in a quarter.

---

✖️ 2.6 – Product

➕ All values-ஐ multiply பண்ண:
➡️ Right-click ➡️ Summarize Values By ➡️ Product
💡 Rarely used but useful for compounding.

---

🔢 2.7 – Count Numbers

🔢 Only numeric cells count பண்ண:
➡️ Use Count Numbers instead of Count (which counts all cells).
🎯 Example: Count of valid amounts only.

---

🧮 2.8 – Show Various Grand Totals

📊 Total rows, columns, or both:
➡️ PivotTable Design ➡️ Grand Totals ➡️ On for Rows/Columns/Both/Off
💡 Custom visibility = clean layout.

---

⚙️ 2.9 – Shortcuts to Field & Value Field Settings

🚀 Speed up customization:

• Right-click field ➡️ Value Field Settings

• Use Alt + JT followed by shortcut keys
  💡 Faster setup for large reports.

---

👁️ 2.10 – See All Pivot Items

📋 Missing data items show பண்ண:
➡️ Right-click row label ➡️ Field Settings ➡️ Layout & Print ➡️ Show items with no data
💡 Ensures all categories stay visible — even if no sales!

---

🔍 2.11 – Show a Unique or Distinct Count

🔁 Repeat values ignore பண்ணி unique count show பண்ண:
✅ Use “Add this data to the Data Model” when creating the Pivot
➡️ Then use Value Field Settings ➡️ Distinct Count
💡 Perfect for counting unique customers, orders, etc.

---

✅ These tools turn your Pivot Table into a data powerhouse — summary, analysis & insights in seconds!