Grand Totals and Subtotals Calculation in rows

[former_member196865]

Hi experts,

I have a Input Schedule that needs the subtotals and grand totals rows.

The report looks like:

                                        Year 1

                                         Data Source

Init Prod Market Account    

100     A     BB     1111          100

100     B     BB     1111          300

200     B     CC     1234          200

200     C     DD     5421          500

I want the report to look like:

                                        Year 1

                                         Data Source

Init Prod Market Account    

100     A     BB     1111          100

100     B     BB     1111          300

100 TOTALS                         400

200     B     CC     1234          200

200     C     DD     5421          500

200 TOTALS                         700

GRAND TOTAL                    1100

Basically totals by the first dimension. While I have been able to achieve the subtotals by member sorting and filtering, it does not show the grand totals. I have tried =sum(epmallmembers) as a local member, but it shows as a #Name?

Regards,

David

[Shrikant_Jadhav · Accepted solution]

Hi David,

For grand total create parent member for total.

create a local member after the row axis.

Shrikant

[former_member196865 · Accepted solution]

Hi Shrikant,

I don't quite get that.

I did create a local Member Total after the row axis. What formula do I put in for it?

I have a page axis that lets the user change the department- which changes INIT dimension.

Regards,

David

[Former Member · Accepted solution]

Hi David,

To achieve this follow the below steps

1)Create your report.

2)Go to edit report then select your Init dimension.

3)Select member sorting and grouping option.

4)Enable member sorting option.

5)Then check mark group by property and select ID.

6)Select After Group and check mark for create local member.

So it will give sub total by Init. Take look at below screen shot.

For grand total create a local member and insert after row axis use below formula for grand total.

"= sum(EPMALLMEMBERS)"

Hope this will solve your problem.

[Former Member · Accepted solution]

Hi David,

When you will create a local member with formula "=sum(EPMALLMEMBERS)" please check that there  is no space in formula if there is a space in formula like   "=sum (EPMALLMEMBERS)" then it will give error like "#name" so please check that.

Hope this will help you to solve your problem.