Cumulative Grand Total Column Matrix Table

Hi,

I am hoping someone can help.

I have a matrix visual and I would like to apply the column grand total but it is giving me the total based on the measure I am using an not the cumulative total.

This is an example of the matrix table and the results I would expect:

The totals are derived using a measure. The model is based on a fact and dimension schema. The Fact table links to a date table that’s how I get the month and year. The fact table also connects to DimArea and that how I get the area.

Does anyone know how I can get the correct cumulative total for the Grand total column?

Thanks

Boycie47