You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Total only items at lvl0 when working with descendants or children of member

Summary:

I'm building a report that can either use descendants or inclusive children on a dimension. The sum formula at the bottom is including the totals of both the parent and the children. Ideally this report would have two levels of children, but for space just saved the one. Is there a formula that can be used to total only the bottom members of the dimension?

I realize that the easy thing to do looking at the image would be to change the text where it says "Calendar Expense Type" but I have yet to figure out how to assign text to only one line when it is one member seledcted.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!