A -possibly- easy issue I'm having trouble with - filtering, extracting data

[dourpil]

Hi all, I hope you're doing great this fine day.

I'm trying to do the following thing but don't really know where to start:
So here is what my sheet looks like:
(A)(B)(C)
X | 1 | 4
Y | 2 | 6
X | 2 | 1
Y | 5 | 6
Y | 7 | 8
X | 4 | 2
I would like to "sort" that data and create this kind of table:
for X
1 | 4
2 | 1
4 | 2
for Y
2 | 6
5 | 6
7 | 8
So it seems I have to play with filters (from what I've seen) but I don't want to have a range of data selected because I want to be able to add data in my first table and have it automatically copied in the corresponding sorted table.
So I don't really want to filter my table but create another one with only the information I need. And I can "only copy filtered data to the active sheet" when I try to use the filter thingy.

I also looked up (pun incoming) stuff about the vlookup (yeey!) function but it doesn't seem to be what I'm looking for.

Any tip - link - stuff - cake you can give me?

Thanks in advance!
Simon

 

[dourpil]

I think it can be a bit tricky working with Pivot charts and some of the functionality might be limited, but in any case I can't see any charts in your example.

Oops I selected the wrong one.. Here it is: http://sdrv.ms/19bf03P

 

[circledchicken]

To get the PivotCharts the way you want, you need to move the CC and TVC fields from the Row Labels area to the Values area of the PivotTable (leaving the only the 'Sort Order' field in the Row area).
You will then get Sum of CC and Sum of TVC measures, which will allow the line charts as per your examples.

 

[dourpil]

To get the PivotCharts the way you want, you need to move the CC and TVC fields from the Row Labels area to the Values area of the PivotTable (leaving the only the 'Sort Order' field in the Row area).
You will then get Sum of CC and Sum of TVC measures, which will allow the line charts as per your examples.

You have no idea how much I want to hug you right now :D

Thank you so so much for all the help provided. I think I'm done with that matter for now!

 

[circledchicken]

Haha - you're welcome and thankyou for the feedback.