Since it is a dashboard, could you use multiple pages with the desired level on each page then use actions or a parameter to only show the desired levels?
Thanks a lot for the alternate solution. This is one of the option, which we have already done, but the users want the way mentioned above. If at all the alternate solution is the only option to handle the current scenerio....then we would like to build the share calculation (complex, wieghted manner) in tableau it self..we would require help in terms of building the calculation...it would be gerat if we could get your email id then we can directly write back. You can drop me a mail in email@example.com.
Thanks a ton. Would appreciate your help.