Sumproduct or another formula for when filtering Pivot Tables

[brian sullivan]

I'm interested in knowing if there is a sumproduct formula, or another (formula) that can remain dynamic when filtering pivot tables. In the attached document, I have filtered my pivot tab which results in a ZERO VALUE for my formula. Thanks. Brian

 

[Hui]

Brian

Have a read of:
http://chandoo.org/wp/about-hui/cha...-no-037-how-to-count-and-sum-filtered-tables/
as well as the comments where other techniques are discussed