Hi,
I have a fact table and a hierarchy and I want that in a report, some measures show value at root level of the hierarchy, but others show null value at that level (or at a level higher than one I set, maybe only leaves), but when I drill down over them,I could see the agregate data in that intermediate levels.
It's possible? Any tip about how to achieve it?¿
Thanks.