On the Portfolio Overview sheet, I'd like for the summary pivot table to show realized capital gains only for taxable accounts, and 0 or blank otherwise. The column total would then give me an indication of my future cap gains tax obligation for all taxable account. I don't think I can filter just the Unrlzd Cap Gain column in the pivot table on Account[Tax] status. At least, I can't figure out how to do it. A new measure (Unrlzd Cap Gain Taxed) tailored from the existing Unrlzd Cap Gain measure might be the solution, but I'm not quite sure what's required in the new measure to achieve the tax status conditioning. Any hints?