I am doing this to get the sum of the Interval in the above expression for the document number that are part of Hierarchy Level 1 = 'Business' but may also be part of other hierarchies. This is working fine.
here comes the tricky part:
Right now it is showing sum of the Interval against all the Document Numbers. But I want it to show only for the Hierarchy Level 1 = 'Business' data. And when a different selection is made, It must show the sum of Interval for the Document numbers that are common between Hierarchy Level 1 = 'Business' and that new selection. Please see the attached screenshots. It might help in understanding my issue.
Your help is much appreciated.
Screenshot 1 : The expression is currently showing the sum of the document numbers across all the Hierarchies.
Screenshot 2 : The expected sum, It is supposed to show the sum for business only.
Screenshot 3 : Suppose a different hierarchy is selected, Then sum of Document NUmbers that are present in business and that new Hierarchy needs to be shown