STEP 1

1. Check F element to chck data integrity (=COUNTA( CONTROL+HOME CHOICE 1 ROW IN 'P' AND CTRL+SHIFT+DOWNROW AND CLOSED TTP KURUNGAN) & ENTER  / OR =COUNTIF(A:A,"p")-1
2.WHEN DOING PIVOT TABLE PLZ PILIH BAWAH TAJUK..1ST ROW.
3.LOCATION PIVOT TABLE FROM THE CORNER TO 
4.CREATE TABLE BARU.. TAX CODE/BASE AMOUNT/GST AMOUNT
5. PILIH SHIFT+* FOR SELECT 'P' ONLY




- GAF TO EXCEL --> PIVOT TABLE --> PIVOT CHART (DEAD TECHNOLOGY)
- BUILD ONCE USE ONCE



---TO USED APRIL PIVOT TABLE&PIVOT CHART FOR MAY ONWORD----

1. GAF TO EXCEL --> PUT IN TABLE & REPLACE -->PIVOT TABLE --> PIVOT CHART (REFRESH)
 GO A2 GO TO INSERT--> TABLE--> OK, GO TO DESIGN CHANGE THE DESIGN COLOR 
2.INSERT --> SLICER --> TAX CODE --> COLUMN UP 3 COLOUMN-->COLOR


---HOW TO REPLACE
GO TO LAST CELL TABLE RIGHT BELOW. PRESS tab.

DELETED APRIL DATA AND COPY DATA MAY & REFRESH SHEET 2.

WHEN DO BIG GAF FILE TAKE ELEMENTS BY ELEMENTS.