Aggregation level question

[rrodriguesrr82]

Hi folks,

I have the following scenario:

Product	Units	NTS
Product A	10	1000
Product B	10	500

• NTS is calculated by the following Formula: Unit Price * Units (There is table for product price in the model)
• Consider that Product A and B have different Unit Prices.

I want to achieve the following result table:

Product	Units	NTS
Product	20	1500

I the table above, I have another dimension level that group Products by Brand. In my example, the brand name is Product.

However, by considering the NTS is not pre-calculated, I mean, NTS is actually an expression that multiplies Unit Price by Units, I'm getting the following NTS value:

• Unit Price for Product A: 100;
• Unit Price for Product B: 50;
• Current Result: 20 * 150 = 3000.

I have tried to use AGGR, but I'm not so familiar with this function.

Do you have some clue?

Best,

Rubens

[Anonymous]

Hello!

Try this:

=Sum(TOTAL AGGR(Sum([Unit Price]*Units), Product))

[sunny_talwar]

or you can just use this

=Sum(Aggr(Sum(Unit Price * Units), Brand, Product))