Is there a way to get the difference between 2 rows as a Grand Total

SharonAtGorilla

I know that the msum function can get that, but I need to display it as a column total not another column.
For instance using the Financials -GL Balance Sheet Subject Area and using Fiscal year

Fiscal Year #Cash
2024 50,000
2025 48,000
Grand Total 2,000

RVohra

Can you see if you can use following formula in a new measure :

CASE
WHEN GROUPING("Fiscal Calendar"."Fiscal Year") = 1 THEN
MAX("Balances"."Ending Balance")
- MIN("Balances"."Ending Balance")
ELSE
"Balances"."Ending Balance"
END