Hi everyone,
I have drill through enabled on my dimensional layer which has a hierarchy. On that item, I put a subtotal. When you drill in the first layer (Company 1) the subtotal will say Company 1. Going down another layer (Department 1) I would want the subtotal to say Department 1 but it still shows Company 1. Is there a way to have the subtotal behavior change as your drill through the different layers of the dimension?
Thanks!