Help with Aggr() function

[sangeess21]

I have an expression using aggr() that I'm struggling with. I'm trying to show Extended Avg Selling Price (Quantity* Avg Selling Price) for CM supplier using a Pivot table. But the total value is not being summed up correctly.

The expression I've used is

if(Match(Dimensionality( ),0,1,2), sum(aggr(sum(Quantity)*[Avg Selling Price],[Purchase Order])), sum(Quantity)*[Avg Selling Price])

I appreciate any help... Thanks!

[MK_QSL · Accepted solution]

Try

SUM(Quantity * [Avg Selling Price])

instead of

sum(Quantity)*[Avg Selling Price])

[balabhaskarqlik]

May be:

if(Match(Dimensionality( ),0,1,2), sum(aggr(sum(Quantity)*Only([Avg Selling Price]),[Purchase Order])), sum(Quantity)*Only([Avg Selling Price]))

[sangeess21]

Thank you. It's working as expected.