/
How to Analyze "P" element with Ms-Excel Pivot Table

How to Analyze "P" element with Ms-Excel Pivot Table

Step 1: Select All > click "Auto Filter" > tick "P" > Copy

Step 2: Paste in "Sheet 2", then "Delete" row 1 for C header

Step 3: Select All > Clcik "Insert" menu > "Pivot Table" > place in new worksheet

Step 4: 

  1. drag the P13_TaxCode to Rows column
  2. drag the P11_PValueMYR & P12_PGSTValueMYR to Values column
  3. clcik on  changed to summarize by "Sum"
  4. highlight Column B & C and then click on  

Private & Confidential