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

[Former Member]

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

[former_member186338]

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

Don't use Member Sorting and Grouping!

[former_member186338]

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.