Sum Issue

[jyothish8807]

Hello All,

I have a pivot table, when I am trying to take the sum I am getting 25, but in actual it should be 50.

I tried the same in straight chart also, but the output is the same.

Any help?

Regards

KC

[sunilkumarqv · Accepted solution]

try this

Sum(aggr(sum (total value),Dimension))

[kavita25]

Hi,

In Straight Table under expression tab, in total mode click on sum of rows by default it is expression total.

In pivot table use aggr function.

for e.g sum(aggr(sum(Sales),Dim1,dim2,dim3))

Regards,

Kavita

[tyagishaila]

Plz share qvw file.. its really strange I want to see it.

Is this Total(50) come from show partial sum?

[jyothish8807]

thanks a lot, I was missing the outer sum part.

Regards

KC

[PrashantSangle]

Hi,

Use Sum(aggr(Sum(Distinct Sales),Dimension))

Regards