Display Cumulative Total for Category, while "simple" Total for Subcategory

[niculeica]

Hi! Is there a way of displaying Cumulative Total for the main breakdown level of a measure in a matrix, while "simple" Total for the subcategories?

I have a "per month" structured matrix, and the hierarchy is Revenue Type -> Revenue Category -> Revenue Subcategory. I would like to display Total of Month for Total per Subcategory, which it does (please see shot below), while Cumulative Total for Total per Category.

This way, Monthly Recurring Revenue for Feb-24 would be calculated as 1170032 + 12271 + 165974.

[v-xinruzhu-msft]

Hi @niculeica 

I have some questions that why the sum of feb-24 is 1170032 + 12271 + 165974, if you want to calculate cumulatively, shoud it be 1170032 + 12271 + 165974+1211396? I don't konw the logic.

and based on your description and picture i cannot create the sample data, can you provide some sample data ?

Best Regards!

Yolo Zhu