Hello;

I have a data from which I have a report as a pivot table.
The data looks something like this:

Col1 Col2 Col3
A 10 12
A 20 12
A 30 12
B 10 14
B 15 14
B 17 14
C 20 15
C 30 15

There are more columns, this is just as a sample.
I'd like to report in the pivot something like the following:
A 12
B 14
C 15

Is there any way to do it?
I cannot sort the original data by unqiue values before. Pivot table gets dynamically updated and I need to keep the data this way.

Many-many thanks!