7 Replies Latest reply on Sep 8, 2016 12:40 AM by praveen p

# How to show grand total of aggregate calculation filed

How to show grand total of aggregate calculation filed.

I have a scenario where i have to show grand total of aggregate function .

data in that filed is coming right but when i turned on grand total value is not perfrect.

Please provide a alternate solution if not possible.

• ###### 1. Re: How to show grand total of aggregate calculation filed

Hi

Please find the screen shot attached. You can see the automatic tab when you click on "Total". From there you can choose the desired option and problem is solved!

1 of 1 people found this helpful
• ###### 2. Re: How to show grand total of aggregate calculation filed

Hi

If you see my first reply, there the Profit Ratio is the Aggregated Measure and the Grand Total comes unexpected! But when you click on "Automatic" and change the aggregations for totals also, you can get the answer. In this case, i am getting the desired value of taotal using the "Sum" of "total".

Hope this helps!!

Thanks

Rahul

• ###### 3. Re: How to show grand total of aggregate calculation filed

Sum function is not coming on right click of aggregate calc.

• ###### 4. Re: How to show grand total of aggregate calculation filed

IF

ATTR([No_])='511502' or

ATTR([No_])='522003' or

ATTR([No_])='523018' or

ATTR([No_])='523029' or

ATTR([No_])='523060' or

ATTR([No_])='522005' or

ATTR([No_])='522007' THEN

SUM([FY 2016-17 Budget Amt]

)/RUNNING_SUM([TotalBudgetCalc])*

RUNNING_SUM([Total Actual New])

ELSE

SUM([FY -2016-17 Actual Amt])

Problem:  when i tried to grand total this calculation field in sheet  it shows sum of else condition in grand total i.e

SUM([FY -2016-17 Actual Amt]) not showing the total of  if conditon.

• ###### 5. Re: How to show grand total of aggregate calculation filed

Hi Shankar

Your problem is quite clear to me! But it would be great if you attach some sample Workbook/data so that it is easy to understand the fields and all

Regards

Rahul

• ###### 6. Re: How to show grand total of aggregate calculation filed

Hi Shankar

probably the issue is with table calculations providing sample workbook would help us

you can go through the below link by Jonathan which might help you quite old post but very useful

1 of 1 people found this helpful