Total Value / Individual Value

[mhmmd_srf]

Hi All,

I have one requirement like :

Percent Sum = Total Sales / Individual Sales.

for the 1st row it would be: 622779.66 *100 / 11020269.20

It should be 5.65 %, however it is coming like 0.60 %.

Could anyone please suggest on this.

I am attaching my app.

[MindaugasBacius]

Do something like this:

=Sum(Sales)/Sum(TOTAL Sales)

[mhmmd_srf]

Hi Bacius,

This expression is already there. Still not working.

Please help.

Thanks,

Sarif

[antoniotiman · Accepted solution]

Maybe

[tresesco]

Null values in dimension are causing the problem. Try expression like:

=sum(ContarctSales)

/ sum(total if (not IsNull(DIM_ITEM.GroupMajorDescription), ContarctSales))

[mhmmd_srf]

It is working..thanks..

[mhmmd_srf]

This is woeking..thanks..

But could you please let me know hoe this property works.

Thanks,

Sarif

[antoniotiman]

This works for Straight Table (Not Pivot)

Provide Rate of Row / Total Column

Regards,

Antonio

[antoniotiman]

Indeed You need only

Sum(Sales) and Check Relative.