Sumif output based on Column not present in Visual

Hey lbendlin ,  the issue is that i'm trying to establish if it is possible to write a dax measure which will aggregate values based on a column not present in a visual,  im aware of 'virtual tables' but don't know much.

I am amble to achieve result in excel only as a result of 2 x pivot tables.
Pivot table 1 contains sales and volume by customer and material attributes (i.e line level detail), and to the right of pvt 1 is a bunch of sumifs based on those attributes.

Pivot table 2 pivots all of pivot 1 + the adjacent formulas, and so I am able to get sumif result (by way of vba to refresh pivot cache) for a single attribute on the basis that all prior hiercarchial attributes are present.

Basically, is it possible to write a measure which will give a sumifs output to a visual based on a column not present in the visual?