Thanks @acordes, I think you're suggesting summing over the entire table and remerging the result with the original table. That will work for the basic table I put in my post as an illustration. Really that table is already a cross tab summarising more detailed underlying data. Nevertheless, in the absence of an ignore filter type functionality, a slightly more complex "group-by-remerge" type approach (either within VA or in the data prep phase) is probably the way to do it so thank you!
... View more