Pivot Chart

[ismailgqr]

[FONT=&quot]Year Month Salesman Customer Name Category Sales 2018 Target for Jan 2019
2018 Jan Peter A Supermarket Milk 20 22
2018 Jan Peter A Supermarket Cheese 30 33
2018 Jan Peter A Supermarket Juice 15 16.5
2018 Jan Peter B Supermarket Milk 15 16.5
2018 Jan Peter B Supermarket Cheese 17 18.7
2018 Jan Peter B Supermarket Juice 22 24.2
2018 Jan John C Supermarket Milk 8 8.8
2018 Jan John C Supermarket Cheese 11 12.1
2018 Jan John C Supermarket Juice 16 17.6
2018 Jan John D Supermarket Milk 25 27.5
2018 Jan John D Supermarket Cheese 32 35.2
2018 Jan John D Supermarket Juice 17 18.7
2018 Feb Peter A Supermarket Milk 16
2018 Feb Peter A Supermarket Cheese 12
2018 Feb Peter A Supermarket Juice 15
2018 Feb Peter B Supermarket Milk 19
2018 Feb Peter B Supermarket Cheese 8
2018 Feb Peter B Supermarket Juice 22
2018 Feb John C Supermarket Milk 24
2018 Feb John C Supermarket Cheese 15
2018 Feb John C Supermarket Juice 6
2018 Feb John D Supermarket Milk 19
2018 Feb John D Supermarket Cheese 13
2018 Feb John D Supermarket Juice 15
2019 Jan Peter A Supermarket Milk 5
2019 Jan Peter A Supermarket Cheese 10
2019 Jan Peter A Supermarket Juice 5
2019 Jan Peter B Supermarket Cheese 6
2019 Jan Peter B Supermarket Juice 8
2019 Jan John C Supermarket Milk 9
2019 Jan John C Supermarket Juice 14
2019 Jan John D Supermarket Milk 18
2019 Jan John D Supermarket Cheese 22[/FONT]
[FONT=&quot]Hi,[/FONT]
[FONT=&quot]Above is the sales record of a company. in Jan 2019 company has increased both salesman target by 10 percent of their Jan 2018 Sales. now I want to analyze Jan 2019 sales with Jan 2019 Target by category and by salesman level.
While I am selecting Jan 2019 sales , I am not able to see Jan 2019 targets and if I select Jan 2018 to include Jan 2019 targets than the sales for the month of Jan is showing for both year 2018 & 2019.[/FONT]
[FONT=&quot]I want to see the pivot chart in as below[/FONT]
[FONT=&quot]Category Target 2018 Sales 2019[/FONT]
[FONT=&quot]Thanks for your help.
Good Day[/FONT]