/
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:
- drag the P13_TaxCode to Rows column
- drag the P11_PValueMYR & P12_PGSTValueMYR to Values column
- clcik on changed to summarize by "Sum"
- highlight Column B & C and then click on
Private & Confidential