How is the grand total calculated?

[misul]

Hello!

I have a .odc file, downloaded from PBI after clicking on Analyse in Excel. I created a normal pivot table in this Excel file and there is a "Grand Total" calculated based off of Years. 

Is there a way to check what kind of formula is used to calculate the Grand Total? It is not the sum or the average or averagea ... I have tried those.

[Stachu]

it's the exact same formula in DAX, the only difference is filter context - multiple years
if you have some syntax modifying Year evaluation context (e.g. hardcoded year filter) it may cause the Total to look funny
can you share the DAX for the measure in question?