Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you post sample data?
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
Sure. Lemme see what I can do