REQUIRED PIVOT IN BELOW FORMAT

[Muhammad Uzair Uddin]

mini sheet vlookup.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
2	Zone	Region	BrickReferenceName	CustomerCode	Chemist Name	ProductReferenceId	Date	Month	TradePrice	SaleUnits	Discount	SaleValue
3	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810595	VICTOR ENTERPRISES	D-CORT	30-12-2021	12-2021	105.17	0.3	0	31.55
4	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810595	VICTOR ENTERPRISES	D-CORT	10-12-2021	12-2021	105.17	0.2	0	21.03
5	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30944231	SALEEM & SONS	D-CORT	02-12-2021	12-2021	105.17	0.3	0	31.55
6	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30944231	SALEEM & SONS	D-CORT	08-11-2021	11-2021	105.17	0.5	0	52.59
7	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	7021632	S. RIAZ UDDIN & CO.	D-CORT	27-12-2021	12-2021	105.17	1	0	105.17
8	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	7021632	S. RIAZ UDDIN & CO.	D-CORT	25-11-2021	11-2021	105.17	2	0	210.34
9	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	7021632	S. RIAZ UDDIN & CO.	D-CORT	18-11-2021	11-2021	105.17	2	0	210.34
10	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	7021632	S. RIAZ UDDIN & CO.	D-CORT	02-11-2021	11-2021	105.17	5	0	525.85
11	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810625	S M ISMAIL	D-CORT	29-12-2021	12-2021	105.17	0.3	0	31.55
12	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	65007027	S D MEDICOS	D-CORT	18-12-2021	12-2021	105.17	1	0	105.17
13	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	65007027	S D MEDICOS	D-CORT	15-11-2021	11-2021	105.17	1	0	105.17
14	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	65007027	S D MEDICOS	D-CORT	02-11-2021	11-2021	105.17	1	0	105.17
15	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810657	NOMAN TRADER	D-CORT	27-12-2021	12-2021	105.17	0.5	0	52.59
16	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810657	NOMAN TRADER	D-CORT	22-12-2021	12-2021	105.17	1	0	105.17
17	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810657	NOMAN TRADER	D-CORT	21-12-2021	12-2021	105.17	1	0	105.17
18	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810657	NOMAN TRADER	D-CORT	18-12-2021	12-2021	105.17	1	0	105.17
19	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810657	NOMAN TRADER	D-CORT	11-12-2021	12-2021	105.17	0.6	0	63.1
20	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	7022020	KAMRAN TRADERS	D-CORT	28-12-2021	12-2021	105.17	0.5	0	52.59
21	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	7022020	KAMRAN TRADERS	D-CORT	24-11-2021	11-2021	105.17	1	0	105.17
22	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	7022020	KAMRAN TRADERS	D-CORT	12-11-2021	11-2021	105.17	0.5	0	52.59
23	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810581	Jasrani Traders	D-CORT	25-12-2021	12-2021	105.17	0.2	0	21.03
24	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	65007052	JANGDAs MEDICOS	D-CORT	28-12-2021	12-2021	105.17	1	0	105.17
25	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	65007052	JANGDAs MEDICOS	D-CORT	27-11-2021	11-2021	105.17	0.5	0	52.59
26	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810610	Ideal Pharma	D-CORT	25-12-2021	12-2021	105.17	1	0	105.17
27	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810610	Ideal Pharma	D-CORT	13-12-2021	12-2021	105.17	0.5	0	52.59
28	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810610	Ideal Pharma	D-CORT	03-12-2021	12-2021	105.17	0.2	0	21.03
29	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810610	Ideal Pharma	D-CORT	29-11-2021	11-2021	105.17	0.2	0	21.03
30	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810610	Ideal Pharma	D-CORT	09-11-2021	11-2021	105.17	0.3	0	31.55
31	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810610	Ideal Pharma	D-CORT	05-11-2021	11-2021	105.17	0.5	0	52.59
32	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810626	FAISAL BROTHERS	D-CORT	10-12-2021	12-2021	105.17	0.5	0	52.59
33	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810626	FAISAL BROTHERS	D-CORT	01-12-2021	12-2021	105.17	0.5	0	52.59
34	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810626	FAISAL BROTHERS	D-CORT	02-11-2021	11-2021	105.17	0.5	0	52.59
35	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810590	CHANDNA IMPEX	D-CORT	30-12-2021	12-2021	105.17	0.5	0	52.59
36	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810590	CHANDNA IMPEX	D-CORT	22-12-2021	12-2021	105.17	0.3	0	31.55
37	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810590	CHANDNA IMPEX	D-CORT	07-12-2021	12-2021	105.17	0.5	0	52.59
38	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810590	CHANDNA IMPEX	D-CORT	12-11-2021	11-2021	105.17	0.5	0	52.59
39	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810609	Ali Pharma	D-CORT	23-12-2021	12-2021	105.17	5	0	525.85
40	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810609	Ali Pharma	D-CORT	24-11-2021	11-2021	105.17	2	0	210.34
41	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810609	Ali Pharma	D-CORT	09-11-2021	11-2021	105.17	1	0	105.17
42	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810609	Ali Pharma	D-CORT	02-11-2021	11-2021	105.17	2	0	210.34
43	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810557	AHMED AND SONS	D-CORT	29-12-2021	12-2021	105.17	1	0	105.17
44	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810557	AHMED AND SONS	D-CORT	27-12-2021	12-2021	105.17	0.6	0	63.1
45	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810557	AHMED AND SONS	D-CORT	21-12-2021	12-2021	105.17	1	0	105.17
46	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810557	AHMED AND SONS	D-CORT	13-12-2021	12-2021	105.17	1	0	105.17
47	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810557	AHMED AND SONS	D-CORT	08-12-2021	12-2021	105.17	1	0	105.17
48	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810557	AHMED AND SONS	D-CORT	27-11-2021	11-2021	105.17	0.5	0	52.59
49	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810557	AHMED AND SONS	D-CORT	19-11-2021	11-2021	105.17	1	0	105.17
50	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	30810557	AHMED AND SONS	D-CORT	06-11-2021	11-2021	105.17	1	0	105.17
51	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	37075600	A Z TRADERS	D-CORT	23-12-2021	12-2021	105.17	0.5	0	52.59
52	SOUTH	01 KHI-2	MARIOT RD/KUTCHI GAL	37075600	A Z TRADERS	D-CORT	06-12-2021	12-2021	105.17	0.6	0	63.1
Sheet1

PIVOT TABLE REQUIRED
RAW DATA IS AVAILABLE IN MINI SHEET

S.No	Chemist Name	Brick ref name	12-2021 sales
1​
2​
3​
4​
5​
6​
7​
8​

 

[Fluff]

In what way is this different to your your thread here Zero chemist sale in dec