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.