Aggregation of limited dimensions

[JonasM95]

Hi together,

I need to calculate a percentage in a chart with 2 dimensions. One is a category for materials and the other is time.

Now I need to divide the category sum by the sum for all categorys. This would be easy, if I could just use TOTAL, but my problem is, that TOTAL also does the sum for the complete selected time frame. I would prefer to see the percentage for each period.

Has anyone a solution for this problem? Thanks in advance.

Best regards

Jonas

[sunny_talwar · Accepted solution]

May be you need this

Sum(Measure)/Sum(TOTAL <Time> Measure)

or may be this

Sum(Measure)/Sum(TOTAL <Category> Measure)

[JonasM95]

The first one works. Thank you!!