Using Name Manager named ranges against a pivot table output

Thanks for this. It works better than my named ranges, however it is now repeating the values for e.g. Customer B has 2 products but is repeating the same values for both products. I have got around this by adding Table_Data[Product] at the end of each formula. Thanks for your help with this.