Display a new key figure as a weighted sum based on a dimension

[VirginiaToledo]

Dear community: 

I have recently created a new key figure, which is a multiplication of two other key figures. I want to be able to display the weighted summary of it, based on a dimension called "ages". 

right now, the total is display without taking in consideration the dimension i have added, and i do not know how to do to weight the total based on this dimension. 

Does somebody know how to do it? 

thanks!

[N1kh1l · Accepted solution]

@VirginiaToledo 

I think you will have to adjust the Exception Aggregation of this Calculated Measure. You could define it as Sum or any other based on what is right for you and in the Exception aggregation dimension you define the dimension on which you want the exception to take place.

Nikhil

[VirginiaToledo · Accepted solution]

HI Nikhil, thank you so much! this has worked perfectly for my case.