How to calculate % in pivot table while having values in rows and months in column

[hafiz_asim]

Hi

I tried to all column with percentage taking sales as a base field without any success,

pivot table i have

	Column Labels
Values	Qtr1	Qtr2	Qtr3	Qtr4	Grand Total
Sum of Sales	3,074,344	2,994,170	2,832,429	2,741,983	11,642,926
Sum of Material	353,440	328,396	389,134	250,242	1,321,212
Sum of Labor	265,472	265,826	339,421	255,910	1,126,629
Sum of other	393,036	308,047	350,530	418,648	1,470,261

<colgroup><col><col><col span="3"><col></colgroup><tbody>
</tbody>

Below one is required

Values	Qtr1	Qtr1 %	Qtr2	Qtr2 %	Qtr3	Qtr3 %	Qtr4	Qtr4 %	Grand Total	Grand Total%
Sum of Sales	3,074,344	100%	2,994,170	100%	2,832,429	100%	2,741,983	100%	11,642,926	100%
Sum of Material	353,440	11%	328,396	11%	389,134	14%	250,242	9%	1,321,212	11%
Sum of Labor	265,472	9%	265,826	9%	339,421	12%	255,910	9%	1,126,629	10%
Sum of other	393,036	13%	308,047	10%	350,530	12%	418,648	15%	1,470,261	13%

<colgroup><col><col><col span="3"><col><col span="5"></colgroup><tbody>
</tbody>

Below is raw data

Months	Job #	Material	Labor	other	Sales
30-Apr-17	1125	14,838	27,220	71,936	468137
31-May-17	1125	93,579	26,566	86,203	480112
30-Jun-17	1125	49,827	40,371	10,420	483332
31-Jul-17	1125	97,867	21,328	96,587	462186
31-Aug-17	1125	60,745	92,615	74,349	461582
30-Sep-17	1125	71,721	69,246	51,933	567170
31-Oct-17	1125	47,790	26,468	73,543	548677
30-Nov-17	1125	37,650	22,135	47,794	453854
31-Dec-17	1125	41,540	35,374	81,973	427450
31-Jan-18	1125	88,142	10,601	77,099	538041
28-Feb-18	1125	71,640	68,795	73,501	577218
31-Mar-18	1125	33,205	60,016	38,397	403901
30-Apr-17	1126	22,166	95,552	48,908	550927
31-May-17	1126	59,579	65,541	51,436	506917
30-Jun-17	1126	88,407	10,576	39,144	504745
31-Jul-17	1126	30,906	21,588	91,022	461967
31-Aug-17	1126	78,996	63,362	19,387	410676
30-Sep-17	1126	48,899	71,282	17,252	468848
31-Oct-17	1126	38,847	40,311	61,437	452426
30-Nov-17	1126	39,429	68,463	78,835	435658
31-Dec-17	1126	44,986	63,159	75,066	423918
31-Jan-18	1126	51,303	54,524	25,512	573109
28-Feb-18	1126	71,606	47,268	95,636	441656
31-Mar-18	1126	37,544	24,268	82,891	540419

<colgroup><col><col><col span="3"><col></colgroup><tbody>
</tbody>

any guidance will be appreciated.

Thanks