hafiz_asim
New Member
- Joined
- Nov 26, 2017
- Messages
- 4
Hi
I tried to all column with percentage taking sales as a base field without any success,
pivot table i have
<colgroup><col><col><col span="3"><col></colgroup><tbody>
</tbody>
Below one is required
<colgroup><col><col><col span="3"><col><col span="5"></colgroup><tbody>
</tbody>
Below is raw data
<colgroup><col><col><col span="3"><col></colgroup><tbody>
</tbody>
any guidance will be appreciated.
Thanks
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