Skip to Content

How to achieve Sub Totals(GL level) and Totals(GL group level) on one dimension(i.e Account)?.

Hi Vadim,

Thank for your response. For Better understanding I am adding more details:

My report has layout has:-

Row Axis: COSTELEMENT, COSTCENTER, LOCATION and DRIVER(Comments)

Column Axis: TIME

Page Axis: AUDITTRAIL,PRODUCT, CATEGORY and RPTCURRENCY

The requirement is:-

1) Sub Totals for each Cost element(G/L account)

2) Total for each G/L group

The attached image shows the way I want the report to look like. A sample of G/L group "Depreciation & Amortization" and it's Cost Elements(G/L accounts).

CostElement hierarchy:

I am able to get Sub Totals of G/L Account(example:410000) using the 'Member Sorting and Grouping' feature with Group by Property = ID, but Totals at G/L Group(example:REV_ACCTS) is empty. Also G/L group TOTAL line is added one line before the last Sub Total of the G/L account. see the attached images below for more clarity.

As we can't use Group by Property for multiple properties, how do I get these Totals at G/L group level ?.

Result after applying the above Member Sorting and Grouping

Thanks,

Mukunda

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 10 at 08:01 AM

    I have already told you: "use hierarchy parents for subtotals and totals"

    Don't use Member Sorting and Grouping!

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09 at 07:56 AM

    First - NEVER use "Insert File" instead of "Insert Image"! Please correct your question to make it readable.

    Second: use hierarchy parents for subtotals and totals.

    Add comment
    10|10000 characters needed characters exceeded