REPORT EDITING

[former_member211812]

Hi Napster's,

I have a requirement Where i need to calculate the total of total,

Based on Product need to calculate the total

I am having three account with category actual need to calculate TOTALS

of all total product.Now the question is How to bring that total in report and it should calculate.

[former_member193143 · Accepted solution]

Hello Mohammed,

Simply create a local member like below ..you will get the grand total at end of your report...

Thank you..

Regards,

Saida Reddy G

[former_member211812 · Accepted solution]

Thanks You

Saida

[former_member211812 · Accepted solution]

Hi Saida,

Hope u remembered we have discussed about GRAND TOTAL By i created a local member But  its coming like this. its calculating all the members i.e answer should be 120 but its showing 240 how to change this...

Thank You

[Shrikant_Jadhav · Accepted solution]

Hi Mohammed,

Can you share the formula of TotalProduct and Total_EPM

Shrikant

[former_member211812 · Accepted solution]

Hi ShriKant

Thanks For Your reply

[Shrikant_Jadhav · Accepted solution]

Hi Mohammed,

Uncheck "Use Excel Cell References"

Shrikant

[Shrikant_Jadhav]

Hi Mohammed,

Kindly go through the below link.

Best way to have hierarchy for grand total.

Shrikant

[former_member211812]

Hi Shrikant,

Thanks for Your replay,

But from that thread am not getting about tat local formula,

it is pointing to create local member means..?

=sum(empallmember)

can please  ellaborate