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
[TABLE="width: 600"]
<colgroup><col><col><col span="3"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD] Column Labels [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Values[/TD]
[TD] Qtr1 [/TD]
[TD] Qtr2 [/TD]
[TD] Qtr3 [/TD]
[TD] Qtr4 [/TD]
[TD] Grand Total [/TD]
[/TR]
[TR]
[TD]Sum of Sales[/TD]
[TD] 3,074,344[/TD]
[TD] 2,994,170[/TD]
[TD] 2,832,429[/TD]
[TD] 2,741,983[/TD]
[TD] 11,642,926[/TD]
[/TR]
[TR]
[TD]Sum of Material[/TD]
[TD] 353,440[/TD]
[TD] 328,396[/TD]
[TD] 389,134[/TD]
[TD] 250,242[/TD]
[TD] 1,321,212[/TD]
[/TR]
[TR]
[TD]Sum of Labor[/TD]
[TD] 265,472[/TD]
[TD] 265,826[/TD]
[TD] 339,421[/TD]
[TD] 255,910[/TD]
[TD] 1,126,629[/TD]
[/TR]
[TR]
[TD]Sum of other[/TD]
[TD] 393,036[/TD]
[TD] 308,047[/TD]
[TD] 350,530[/TD]
[TD] 418,648[/TD]
[TD] 1,470,261

[/TD]
[/TR]
</tbody>[/TABLE]



Below one is required

[TABLE="width: 1170"]
<colgroup><col><col><col span="3"><col><col span="5"></colgroup><tbody>[TR]
[TD]Values[/TD]
[TD] Qtr1 [/TD]
[TD] Qtr1 % [/TD]
[TD] Qtr2 [/TD]
[TD] Qtr2 % [/TD]
[TD] Qtr3 [/TD]
[TD] Qtr3 % [/TD]
[TD] Qtr4 [/TD]
[TD] Qtr4 % [/TD]
[TD] Grand Total [/TD]
[TD] Grand Total% [/TD]
[/TR]
[TR]
[TD]Sum of Sales[/TD]
[TD] 3,074,344[/TD]
[TD="align: right"]100%[/TD]
[TD] 2,994,170[/TD]
[TD="align: right"]100%[/TD]
[TD] 2,832,429[/TD]
[TD="align: right"]100%[/TD]
[TD] 2,741,983[/TD]
[TD="align: right"]100%[/TD]
[TD] 11,642,926[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]Sum of Material[/TD]
[TD] 353,440[/TD]
[TD="align: right"]11%[/TD]
[TD] 328,396[/TD]
[TD="align: right"]11%[/TD]
[TD] 389,134[/TD]
[TD="align: right"]14%[/TD]
[TD] 250,242[/TD]
[TD="align: right"]9%[/TD]
[TD] 1,321,212[/TD]
[TD="align: right"]11%[/TD]
[/TR]
[TR]
[TD]Sum of Labor[/TD]
[TD] 265,472[/TD]
[TD="align: right"]9%[/TD]
[TD] 265,826[/TD]
[TD="align: right"]9%[/TD]
[TD] 339,421[/TD]
[TD="align: right"]12%[/TD]
[TD] 255,910[/TD]
[TD="align: right"]9%[/TD]
[TD] 1,126,629[/TD]
[TD="align: right"]10%[/TD]
[/TR]
[TR]
[TD]Sum of other[/TD]
[TD] 393,036[/TD]
[TD="align: right"]13%[/TD]
[TD] 308,047[/TD]
[TD="align: right"]10%[/TD]
[TD] 350,530[/TD]
[TD="align: right"]12%[/TD]
[TD] 418,648[/TD]
[TD="align: right"]15%[/TD]
[TD] 1,470,261[/TD]
[TD="align: right"]13%[/TD]
[/TR]
</tbody>[/TABLE]

Below is raw data

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

any guidance will be appreciated.

Thanks