Pivot Table issue

[#1]

I have sample Excel file and the Qvw attached.

I am using the Pivot table but the partial sum is showing blank instead of the total sum of that row.Can anyone hep me here ?

Thanks,

Alva.

[Frank_Hartmann]

just use sum(value) as expression!

hope this helps

[sunny_talwar · Accepted solution]

Try using an aggregation function such as Sum or Count

=Sum(Value)

[#4]

change the expression for =sum(Value)

[#5]

Thanks much

[#6]

Thanks much

[#7]

Thanks much