3 Replies Latest reply on Dec 21, 2016 11:23 PM by koushik.neelakantha

# Sum of Grand total

Hello everyone,

I need to get the Sum of Column Grand total.

For sub totals i am taking average of the measure but my grand total should be sum of the Subtotals not the average.

Calculation:

if first() = last () then AVG([Last 12 Months Sales]) END

Regards,

Koushik.

• ###### 1. Re: Sum of Grand total

Hey Koushik,

We're going to need more information such as a packaged workbook in order to give you a helpful answer. However, grant totals can be pretty tricky as they require a strong understand of the level of aggregation. This is a great place to start learning:

-Diego

• ###### 2. Re: Sum of Grand total

Hello Diego,

Thanks a lot for your reply. I am unable to attach workbook. I can explain you with the clear screen shots.

Requirement:

I need to get the sum of subtotals as a  GRAND TOTAL.

1) I am using below logic for hiding Row level Values with the average function and selecting compute using--> Pane down. Below screenshot is the average of the subtotals hiding row level Values.

if first() = last () then AVG([Last 12 Months Sales]) END

Regards,

Koushik.

• ###### 3. Re: Sum of Grand total

Hello,

Please find the attached workbook and Kindly look into Last 12 months sales.

1) As my Last 12 months sales are repeating, My subtotal should be average of row level and hide the row level values. ( Screenshot 1)

2) As I am taking average of subtotals , my grand total should be SUM of subtotals.(Screenshot 2)

Regards,

Koushik