Hi Excel Gurus, I need your help desperately. Person who can help will definitely get lots of good wishes, and amazon cheapest gift voucher. That is all I can afford.

PROBLEM:

I have in Pivot different rows

Country, Client ID, Tiers (Meaning different clusters), Goals, Meetings

Country Tier Client ID Goals

IN 1 14 06
1 17 11
1 18 09

2 25 12
2 14 13

3 10 05

US
UK
AU


This is how the pivot looks. Now what do I want.

I want to for every country and Tier find the top quartile.

Problem is with Pivot I cant pull a formula as the Range for quartile will end with every country and Tier. How can I do this?

Thanks,
Saurav