Versions Compared

Version Old Version 1 New Version Current
Changes made by

Jia Pei Chan

Jia Pei Chan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Image Added

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

Image Added

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

Image Added

Step 4: 

Image Added

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