Tables didnt format. I've updated the below in a PDF version where table formatting exists.

Eiriksson it's not quite what I'm looking for as that will provide a total Sale the same across every year for every person because its over All Sales (I think()ie if I Slice by Name,, I get the total Values of 57, 79 and 136

Data Set is

YearNameMarketDomestic SalesForeign SalesTotal Sales

2014JoanPoland2222

2015JoanIreland2424

2016BobEngland2020

2016BobIreland1010

2016JohnFrance1212

2016MaryEngland2525

2016MaryIreland2323

5779136

Required End Result

Capture Total, Domestic, Foreign Sales per Year Per Person.

For example Slice on Year 2016 I would like to get

YearDomestic SalesForeign SalesTotal Sales

2016335790

Include Name into the Report

YearNameDomestic SalesForeign SalesTotal Sales

2016Bob102030

2016John1212

Mary232548

If I Slice my Market "Ireland" I currently get this

YearNameDomestic SalesForeign SalesTotal Sales

2016Bob1010

Mary2323

If I Slice my Market "England" I currently get this

YearNameDomestic SalesForeign SalesTotal Sales

2016Bob2020

Mary2525

What I am looking for would be when Sliced by England.

YearNameTotal Domestic SalesTotal Foreign SalesSliced Market SaleTotal Sales

2016Bob10202030

Mary23252048

If both Bob and Mary exported to France in addition to England in 2016 by 10 then my table would look like

YearNameTotal Domestic SalesTotal Foreign SalesSliced Market SaleTotal Sales

2016Bob10302040

Mary23352058