1.6 DESIGN TAB - LAYOUT GROUP

👇 Watch & share if you love this content!

🖥️ Check this out: Pivot Table Layout

---

🔢 1.61 – Subtotals

🧮 Pivot Table-ல் each group-க்கு subtotal காட்டலாம்.
Example: Region-wise sales subtotal.
➡️ PivotTable Analyze tab ➡️ Subtotals
Options:

• 🟢 Show at top of group

• 🔵 Show at bottom

• 🔴 Don’t show subtotals (if not needed)
  💡 Helps to break down summary data into sections.

---

🧮 1.62 – Grand Totals

📊 Overall total values-ஐ display பண்ண:
➡️ PivotTable Design tab ➡️ Grand Totals
You can show/hide:

• 💯 Grand Totals for Rows

• 💯 Grand Totals for Columns

• Or both
  ✅ Gives big-picture insights at a glance.

---

🧾 1.63 – Report Layouts

🗂️ Report layout changes பண்ண Excel-ல், data readability improve ஆகும்.
➡️ PivotTable Design tab ➡️ Report Layout
Options:

• 🟨 Compact Form (default – space-saving)

• 🟦 Outline Form (each field in separate row)

• 🟥 Tabular Form (classic, clean, row-based)
  💡 Best option depends on your reporting need.

---

⬜ 1.64 – Blank Rows

🧼 Data visually separate பண்ண space வேணுமா?
➡️ Insert Blank Rows between groups:
PivotTable Design ➡️ Blank Rows ➡️ Insert Blank Line after Each Item
👁️‍🗨️ Improves clarity – especially for printing or presentations.

---

🧱 1.65 – Show the Classic Pivot Table Layout

📋 Old Excel version-ல இருந்த drag-and-drop grid layout missing-aa?
🎯 You can bring it back!
➡️ Right-click on Pivot ➡️ PivotTable Options ➡️ Check ✅ “Classic PivotTable Layout”
🔧 This allows fields to be dragged directly into the layout area – super handy for old-school users!

---

🎨 These features make your Pivot Table not just smart, but presentable too!
📊 Structured + Clear = Report ready for boss/client! 😎