Pivot Chart

Year Nonth Saleman Customer Name Category Sales 2018 Target for Jan 2019
2018 Jan Peter A Supermarket Milk 20 22
2018 Jan Peter A Supermarket Chees 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 Chees 17 18.7
2018 Jan Peter B Supermarket Juice 22 24.2
2018 Jan Jhon C Supermarket Milk 8 8.8
2018 Jan Jhon C Supermarket Chees 11 12.1
2018 Jan Jhon C Supermarket Juice 16 17.6
2018 Jan Jhon D Supermarket Milk 25 27.5
2018 Jan Jhon D Supermarket Chees 32 35.2
2018 Jan Jhon D Supermarket Juice 17 18.7
2018 Feb Peter A Supermarket Milk 16
2018 Feb Peter A Supermarket Chees 12
2018 Feb Peter A Supermarket Juice 15
2018 Feb Peter B Supermarket Milk 19
2018 Feb Peter B Supermarket Chees 8
2018 Feb Peter B Supermarket Juice 22
2018 Feb Jhon C Supermarket Milk 24
2018 Feb Jhon C Supermarket Chees 15
2018 Feb Jhon C Supermarket Juice 6
2018 Feb Jhon D Supermarket Milk 19
2018 Feb Jhon D Supermarket Chees 13
2018 Feb Jhon D Supermarket Juice 15
2019 Jan Peter A Supermarket Milk 5
2019 Jan Peter A Supermarket Chees 10
2019 Jan Peter A Supermarket Juice 5
2019 Jan Peter B Supermarket Chees 6
2019 Jan Peter B Supermarket Juice 8
2019 Jan Jhon C Supermarket Milk 9
2019 Jan Jhon C Supermarket Juice 14
2019 Jan Jhon D Supermarket Milk 18
2019 Jan Jhon D Supermarket Chees 22

Hi,

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.

I want to see the pivot chart in as below

Category Target 2018 Sales 2019

Thanks for your help.
Good Day

Hi ismailgqr,

I think this is what you after - please see attached.

Regards

peterrc

Thanks for your replay Peter, but I want to see Jan 2019 target in one column and Jan 2019 sales in the next column to compare the achievement.

Hi ismailgqr,

Like this ?

Regards

peterrc

This is great, you solved my problem peter.
Thank you so much

Hi ismailgqr,

Thanks for the feedback.
Glad to help.
When you get chance can you please mark your thread as "Solved".

Regards

peterrc