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
Bookmarks