Hi, We have following use case for non-additive measure. We want to know whether it is possible to handle following use case in Visual analytics 7.1 and if yes then how. Use case as follows : We have return data at 3 levels of hierarchy. Below figure shows Parent as 1, 2 and 3 are next level nodes and last 4,5,6,7,9,10 are child nodes. Each child node has return value (shown in green color). At the same time we have return data calculated at node 2 & 3, and node 1 again shown in green color. What we want to create is return_pct measure with non-additive nature. So ideally when following reports is created (Figure 1), then it shows correct return values. When we drill up to next level, it shows aggregated value for node 2 & 3 (Figure 2), whereas, it should show real pre-calculated values as 2.3 and 1.9 respectively. We want to know, how to create non-additive measure so that we can create correct report. Thanks ~PB
... View more