Pivot Table expression row count

[help4qv123]

Hello Experts,

I have some problem in partial count of an expression.

javascript:;

Chart1 is the default chart of a pivot table. In the third expression the logic is if the 2nd exp value <>0 then only those values should appear. That's fine. But when i apply partial sum that also applies to the missing value. Instead of 78 i am getting the same 79.

QVW attached. !

[sunny_talwar · Accepted solution]

Try this

=Sum(Aggr(If(Sum(Exp2)<>0,

Sum(FullYear)), Dim1, Dim2))

[help4qv123]

Thank You . It worked

[help4qv123]

I have tried the same. but i missed to write sum here (...Sum(Exp2).

Thanks:)