PIVOT TABLE (Excel)
📘 PIVOT TABLE (Excel) 1️⃣ à´Žà´¨്à´¤ാà´£് Pivot Table? (What is Pivot Table?) Pivot Table à´Žà´¨്നത് MS Excel à´²െ à´’à´°ു data summary tool ആണ്. Large data à´Žà´³ുà´ª്പത്à´¤ിൽ summarize à´šെà´¯്à´¯ാà´¨ും analyse à´šെà´¯്à´¯ാà´¨ും ഉപയോà´—ിà´•്à´•ുà´¨്à´¨ു. 👉 Simple definition: Pivot Table is a tool used to summarize and analyze large data easily. 2️⃣ à´Žà´¨്à´¤ിà´¨ാà´£് Pivot Table ഉപയോà´—ിà´•്à´•ുà´¨്നത്? (Why we use Pivot Table?) Total à´•à´£്à´Ÿെà´¤്à´¤ാൻ (Find Total) Average à´•à´£്à´Ÿെà´¤്à´¤ാൻ (Find Average) Count à´•à´£്à´Ÿെà´¤്à´¤ാൻ Product / Month / Class à´ª്à´°à´•ാà´°ം summary തയ്à´¯ാà´±ാà´•്à´•ാൻ Report തയ്à´¯ാà´±ാà´•്à´•ാൻ 3️⃣ Example 1 – Sales Data Date Product Salesman Amount Jan Pen Arun 500 Jan Pencil Arun 300 Feb Pen Manu 700 Feb Pencil Arun 400 Mar Pen Manu 600 🎯 Question: Product à´ª്à´°à´•ാà´°ം Total à´•à´£്à´Ÿെà´¤്à´¤ുà´• 🪜 Steps: Full table select à´šെà´¯്à´¯ുà´• Insert → Pivot Table click à´šെà´¯്à´¯ുà´• OK click à´šെà´¯്à´¯ുà´• Product → Rows area à´²േà´•്à´•് drag à´šെà´¯്à´¯ുà´• Amount → Values area à´²േà´•്à´•് drag à´šെà´¯്à´¯ുà´• ✅ Result: Product Total Amount Pen 1800 Pencil 700 ...