My app uses 6 filters, three relating to dates (month,quarter and year) and three relation to employees and groups (employees belong to divisions and divisions belong to departments)
I have built and implemented a hierarchy table for the employee>division>department relationships.
Sum({1<NodeID={$(=DepartmentID)}>}Dept_Visits) works great for the employee side of the equation, but I need to add the segment that will follow selections made on the date side.
In short, I need to mix Sum({1}Dept_Visits) and Sum({$}Dept_Visits) in a single statement.
