This content has been marked as final. Show 2 replies
I need some assistance regarding the following. We have ahierarchical data.
Sales manager zone, State, Region, HQ name (HQ is the lowest grain and sales manager zone is the highest grain).
I have a calculated field named Productivity.
The formula is Sum(sales)/number of reps by HQ
Till HQ level the calculation seems to work. However when I am using Region/ any other higher level its not working.
Eg. for Region = "chandigarh"
Net sales = 3744001.91
reps: 27 (for all the HQ within Chandigarh)