OP's initial post was 7/25/2018. They've been waiting a while. Has uploaded a workbook. OP wants to do calculations on a table, pivot table and multiple slicers ... I think.

I have no idea what they are trying to do and I cannot come up with a coherent question.

https://www.excelforum.com/excel-gen...ml#post4950461