Sorting in Pivot table

[AR90]

Hi

Need help with sorting in Pivot table. I need the top 3 of these (not from every country, but total top 3 cars from this table- cannot find the place to do this).
Current Pivot table:
FINLAND
Golf 200
A4 400
Sweden
Golf 100
A8 500
BMW X5 600
Germany
Porshe 700

What I need:
Germany
Porshe 700
Sweden
BMW X5 600
A8 500

Thanks

[oeldere]

You get better help on your question if you add the excel file, without confidential information.

Please also add the desired (expected) result.

[AR90]

Added File.

[oeldere]

value filter => top 10 (change the value in 3).
after that (regular) sort on column B

See the attached file.

[AR90]

This does not work unfortunately. I need to find the top 3 cars (with countries)

You just missed the countries, however these are important

[oeldere]

In #1 you asked

Please Login or Register  to view this content.

So I made it that way.

Here is the new file, with the new request.

[AR90]

That's what I meant that not for each country. I need top three cars from the hole table.

Meaning showing only this:
Germany
Porshe 340
Audi A4 191

Italy
Audi A4 163

Not sure if this can be done

[oeldere]

Non Pivot table solution.

See the yellow cells.

[AR90]

Thanks for that, I guess that there isn't pivot table solution for this then. Thank you for you help.

[oeldere]

with an helpcolumn and a pivot table.

See the attached file.

[AR90]

Thanks Oeldere. That's an amazingly easy way to fix solve this problem. Thank you.

[oeldere]

Thanks for the reply.

Glad I could help.

You can click on the star on the left side to give rep(utation) to the one's who helped you.