I need to perform a simple (division/percentage) calculation that updates at each level of the drill down but for some reason it is not working automatically, so I'm now trying to use IF/THEN logic based on hierarchy level expanded as a work around. This can get more complex, after I have the solution for the horizontal hierarchy (Category, Sub-category, Manufacturer, Product) I will then need to come up for similar logic for vertical date (Year, Quarter, Month) hierarchy.
3 Antworten
