Sum of Total values Showing Different

[prma7799]

Hi All,

I have taken calculation of (Sum*Avg)  but in my chart the sum value is not showing properly.

Thanks

[fvelascog72]

Hi,

The difference is that in excel your result is the sum of the partial totals and in QV is calculating dimensioned average.

It´s deppends what you need.

Saludos.

[prma7799]

I need sum of all rows like 1066.73

[fvelascog72]

Try this: Sum of rows

Saludos.

[prma7799]

I need this in Pivot table.

[fvelascog72]

Try with:

Sum(Aggr((sum(Gross)*avg(net))/100,id)) in col3 expression

Saludos

[prma7799]

Hi,

I have tried this in my live application earlier but not achieve.

Thanks 

[fvelascog72]

File attached.