Hi, Can you provide the dummy data, as provided data is not the complete one, it seems you have provided pivot table data.
Regards Shekhar Sharma On Fri, Apr 20, 2012 at 3:28 PM, Soni.Rajender <soni.rajen...@gmail.com>wrote: > Dear Team > > Thanks for the reverts. > > Please find attached the file having my requirement. > > Regards > Rajender Soni > > > On Thursday, April 19, 2012 4:26:09 PM UTC+5:30, Soni.Rajender wrote: > >> Dear Team >> >> Please find attached the excel workbook having a pivot table in one sheet >> and the relevant data in other sheet. >> >> I want to display the top 3 states zonewise in the pivot table e.g. for >> the zone - central, only top 3 states should be visible and similarly for >> other zones. >> >> Please help. >> >> Regards >> Rajender Soni >> > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- Shekhar Sharma 9910010060 "Life consists not in holding good cards but in playing those you hold well" "Before you judge another, think of your own last mistake." -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
