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:
Thanks a lot for your reply. I am unable to attach workbook. I can explain you with the clear screen shots.
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
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)