Set Expression

[md_qlikview]

Hello All,

I want to calculate sales done by a managers on a given time period. Currently I am getting rolled up values in which his subordinate values are also getting included who are at different levels below respective managers eg. Level 2-4. How do I exclude his subordinates values from total of managers sales who are at level one? Is there any way to do this using set expression?

Thanks In Advance

[robert_mika]

Could you post  sample data?

[Gysbert_Wassenaar]

Your question can't be answered without more information about your data model. Can you post a small qlikview document that demonstrates the problem? See this document: Preparing examples for Upload - Reduction and Data Scrambling

[md_qlikview]

Sure. Lemme see what I can do