I am trying to use calculated item in excel to add together 2 items in a field. the formula is very simple and works great: =Committed+'Open Role' except for the fact it adds together every combination even when there aren't values for Committed and Open Roles. This completely blows the pivot table up with a lot of blank rows. Ideally I would want the calculated item to only calculate when either Committed or Open Role has a value. Or is there a way to filter them out of the pivot table?