Thanks for your reply.
Actually we have 6 prompts in one dashboard prompt.
1. Ministry Market
1 to 4 are in one hierarchy and year,month in one hierarchy.when we use Limit values by All Prompts not working.
Finally we came to know that when we use Limit values by All Prompts will work for only one hierarchy.So we have created 2 dashbord prompts for this scenario.