Forum Stats

  • 3,852,315 Users
  • 2,264,091 Discussions
  • 7,905,025 Comments

Discussions

Financial Reporting - HFM and Parent/Child formatting

674003
674003 Member Posts: 1
edited Dec 7, 2008 1:30PM in Hyperion Query and Reporting
I have a report that has many rows, each with the same logic: Children of Account(Inclusive).

I would like to have the parent formatted differently than the children (ie lines to show that it is a subtotal). Is this possible?

I can remove the inclusive part and then add an Auto Calculation Total to each row and then hardcode the Auto Calculation Heading, but am looking for a more dynamic approach.
Tagged:

Answers

  • 631379
    631379 Member Posts: 660
    I use 2 rows to accomplish this.

    Children[Account] - this is not inclusive
    Sum([1])

    I use a Custom Heading for the summary row. This method allows you to put the sub total at the bottom and format as needed.
This discussion has been closed.