Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
I want to add to total column to a pivot table.But if i am adding total column it is getting applied to all dimensions.I want only one total colum which gives total of sales for all months.
I want to add Total as first column in the pivot table .
Thanks
Can you share some dummy Data.
Hi I couln't share the app because of it size .
Below is the screen shot
In the below table Total should not be displayed for every dimensional vale.If i add as expression it is getting applied to all groups .It should be one single seperate column.
It should be one Total column.
How to achieve this
PERIOD_ALPHA | 2015.01 | 2015.02 | 2015.03 | 2015.04 | 2015.05 | 2015.06 | 2015.07 | 2015.08 | 2015.09 | 2015.10 | 2015.11 | 2015.12 | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Anlytical Account | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total | Bgt Value | Bgt % | Total |
Net Sales | 2083 | 9.5% | 2083.0162240211 | 1588 | 7.2% | 1588.1677401091 | 1788 | 8.1% | 1788.1501105224 | 1692 | 7.7% | 1691.9464725649 | 1807 | 8.2% | 1806.7210836693 | 2039 | 9.3% | 2039.3786229751 | 1778 | 8.1% | 1777.7926434666 | 1720 | 7.8% | 1720.3827870427 | 1798 | 8.2% | 1798.2906916886 | 1869 | 8.5% | 1868.6443857201 | 1852 | 8.4% | 1852.3976885914 | 1946 | 8.9% | 1946.3825325695 |
Cost of Sales before Waste | (1943) | (8.8)% | -1943.1077714042 | (1460) | (6.6)% | -1459.5942852398 | (1649) | (7.5)% | -1649.4904733768 | (1559) | (7.1)% | -1558.6405482608 | (1664) | (7.6)% | -1664.491259359 | (1908) | (8.7)% | -1907.5781888665 | (1633) | (7.4)% | -1633.3927987938 | (1572) | (7.2)% | -1571.5477072691 | (1737) | (7.9)% | -1737.0746315163 | (1808) | (8.2)% | -1807.5847611302 | (1800) | (8.2)% | -1800.2590742867 | (1881) | (8.6)% | -1880.8618638221 |
Waste | (18) | (0.1)% | -17.620455201472 | (16) | (0.1)% | -16.052796685534 | (18) | (0.1)% | -17.816444268727 | (17) | (0.1)% | -17.223668540978 | (18) | (0.1)% | -18.224645363911 | (20) | (0.1)% | -20.117282883926 | (19) | (0.1)% | -18.614614693557 | (18) | (0.1)% | -18.078363071671 | 64 | 0.3% | 64.384158496817 | 63 | 0.3% | 63.274184049975 | 68 | 0.3% | 68.129850307281 | 73 | 0.3% | 73.484562031369 |
Gross Margin Before Shrinkage | 122 | 0.6% | 122.28799741038 | 113 | 0.5% | 112.52065818356 | 121 | 0.6% | 120.84319288152 | 116 | 0.5% | 116.08225576487 | 124 | 0.6% | 124.00517896498 | 112 | 0.5% | 111.68315122764 | 126 | 0.6% | 125.78522997079 | 131 | 0.6% | 130.75671672293 | 126 | 0.6% | 125.60021866654 | 124 | 0.6% | 124.33380863039 | 120 | 0.5% | 120.26846461451 | 139 | 0.6% | 139.00523079189 |
Shrinkage | (9) | (0.0)% | -8.6969653536018 | (8) | (0.0)% | -7.8595360820564 | (9) | (0.0)% | -9.0174295899932 | (10) | (0.0)% | -9.5760015059655 | (10) | (0.0)% | -10.240383465295 | (12) | (0.1)% | -11.721051459453 | (10) | (0.0)% | -10.187198094537 | (10) | (0.0)% | -9.9823768823057 | (11) | (0.0)% | -10.8244848866 | (11) | (0.0)% | -10.891107125341 | (11) | (0.0)% | -10.774602654329 | (12) | (0.1)% | -12.252441844633 |
Gross Margin | 114 | 0.5% | 113.5910320572 | 105 | 0.5% | 104.66112210154 | 112 | 0.5% | 111.82576329154 | 107 | 0.5% | 106.50625425822 | 114 | 0.5% | 113.76479549935 | 100 | 0.5% | 99.962099767924 | 116 | 0.5% | 115.59803187572 | 121 | 0.5% | 120.77433984099 | 115 | 0.5% | 114.77573378063 | 113 | 0.5% | 113.44270150503 | 109 | 0.5% | 109.49386196004 | 127 | 0.6% | 126.75278894799 |
Rebates & Suppliers Benefits H.O | 236 | 1.1% | 236.43219591787 | 198 | 0.9% | 198.26708065639 | 217 | 1.0% | 217.00386339142 | 205 | 0.9% | 204.99602861251 | 222 | 1.0% | 222.18329668315 | 259 | 1.2% | 259.15691601116 | 229 | 1.0% | 228.84395582827 | 215 | 1.0% | 215.02466149638 | 233 | 1.1% | 232.5949766952 | 238 | 1.1% | 238.28579909352 | 244 | 1.1% | 244.27329176571 | 259 | 1.2% | 258.717405877 |
Promo Activities & Other Fees - Stores | 31 | 0.1% | 30.578277759249 | 29 | 0.1% | 28.928140743407 | 30 | 0.1% | 30.382940503328 | 30 | 0.1% | 29.984561853105 | 31 | 0.1% | 31.371692440045 | 34 | 0.2% | 33.64164134602 | 32 | 0.1% | 31.775513171609 | 31 | 0.1% | 31.105677487145 | 31 | 0.1% | 31.278961262014 | 32 | 0.1% | 31.906379053221 | 31 | 0.1% | 30.766247669785 | 32 | 0.1% | 31.664984944945 |
Rebates & Suppliers Benefits | 267 | 1.2% | 267.01047367787 | 227 | 1.0% | 227.19522140003 | 247 | 1.1% | 247.38680389381 | 235 | 1.1% | 234.98059046543 | 254 | 1.2% | 253.55498912188 | 293 | 1.3% | 292.7985573587 | 261 | 1.2% | 260.61946899784 | 246 | 1.1% | 246.13033898364 | 264 | 1.2% | 263.8739379574 | 270 | 1.2% | 270.19217814883 | 275 | 1.3% | 275.03953943403 | 290 | 1.3% | 290.38239082284 |
Net Logistic Cost | (8) | (0.0)% | -8.219617165824 | (8) | (0.0)% | -7.6005985655825 | (6) | (0.0)% | -5.7246264955389 | (6) | (0.0)% | -6.4478228826694 | (8) | (0.0)% | -7.8543300002292 | (8) | (0.0)% | -8.2337019006435 | (7) | (0.0)% | -6.9418828101269 | (7) | (0.0)% | -6.6768790620389 | (6) | (0.0)% | -5.6726444968584 | (7) | (0.0)% | -6.6458308874688 | (6) | (0.0)% | -5.9568890279409 | (6) | (0.0)% | -5.893016720007 |
Commercial Margin | 372 | 1.7% | 372.3818885706 | 324 | 1.5% | 324.25574493483 | 353 | 1.6% | 353.48794069221 | 335 | 1.5% | 335.03902184316 | 359 | 1.6% | 359.46545462137 | 385 | 1.8% | 384.52695522366 | 369 | 1.7% | 369.27561806603 | 360 | 1.6% | 360.22779976189 | 373 | 1.7% | 372.97702724062 | 377 | 1.7% | 376.98904876438 | 379 | 1.7% | 378.57651236812 | 411 | 1.9% | 411.24216304862 |
Other Revenue | 12 | 0.1% | 11.836537578334 | 11 | 0.0% | 10.814422783958 | 11 | 0.1% | 11.094036785815 | 11 | 0.1% | 11.127844573039 | 11 | 0.1% | 11.23165403566 | 12 | 0.1% | 12.23461125593 | 12 | 0.1% | 11.594593004492 | 11 | 0.1% | 11.056661326734 | 12 | 0.1% | 11.532760293966 | 12 | 0.1% | 11.718415601118 | 12 | 0.1% | 11.890186395551 | 12 | 0.1% | 12.24430375946 |
Financial Margin | 8 | 0.0% | 8.1477655745751 | 7 | 0.0% | 7.4234295092831 | 7 | 0.0% | 7.2808229921336 | 7 | 0.0% | 7.0638519103106 | 7 | 0.0% | 7.1523813360575 | 7 | 0.0% | 7.4570397285893 | 7 | 0.0% | 7.1991669289406 | 7 | 0.0% | 7.0237709905373 | 7 | 0.0% | 7.3347086010893 | 7 | 0.0% | 7.4426263368847 | 7 | 0.0% | 7.4422129955425 | 8 | 0.0% | 7.5840697359724 |
Total Commercial Margin | 392 | 1.8% | 392.36619172065 | 342 | 1.6% | 342.49359722877 | 372 | 1.7% | 371.86280046786 | 353 | 1.6% | 353.23071832626 | 378 | 1.7% | 377.84948999453 | 404 | 1.8% | 404.21860621295 | 388 | 1.8% | 388.06937799866 | 378 | 1.7% | 378.3082320802 | 392 | 1.8% | 391.84449613489 | 396 | 1.8% | 396.15009070266 | 398 | 1.8% | 397.90891175707 | 431 | 2.0% | 431.07053654501 |
Staff Costs | (135) | (0.6)% | -134.69030020517 | (133) | (0.6)% | -132.78895534694 | (136) | (0.6)% | -135.77143346839 | (135) | (0.6)% | -135.43748166439 | (136) | (0.6)% | -136.30505065838 | (140) | (0.6)% | -139.82248464188 | (144) | (0.7)% | -143.50542510046 | (139) | (0.6)% | -138.50954641489 | (143) | (0.7)% | -142.77841784346 | (144) | (0.7)% | -143.85540750763 | (143) | (0.7)% | -142.82258226966 | (146) | (0.7)% | -145.88619808074 |
Marketing & Advertising | (13) | (0.1)% | -13.446012262121 | (9) | (0.0)% | -9.4135495430606 | (11) | (0.0)% | -10.816033790597 | (11) | (0.0)% | -10.576543960866 | (12) | (0.1)% | -11.671971870824 | (14) | (0.1)% | -13.501368534605 | (10) | (0.0)% | -10.061610312436 | (10) | (0.0)% | -10.003175772275 | (10) | (0.0)% | -10.344710057852 | (13) | (0.1)% | -12.586295460996 | (14) | (0.1)% | -13.604942283678 | (12) | (0.1)% | -11.590640879028 |
Other Operating Expenses | (65) | (0.3)% | -64.80729605248 | (61) | (0.3)% | -60.81806585769 | (64) | (0.3)% | -64.203977421059 | (65) | (0.3)% | -64.987916091471 | (67) | (0.3)% | -67.325845085038 | (73) | (0.3)% | -72.685426184431 | (72) | (0.3)% | -71.645511202817 | (70) | (0.3)% | -70.042629607249 | (72) | (0.3)% | -71.536390517522 | (71) | (0.3)% | -71.209083652626 | (70) | (0.3)% | -69.952462710054 | (72) | (0.3)% | -72.227717099286 |
Result From Activity | 179 | 0.8% | 179.4225832013 | 139 | 0.6% | 139.47302648014 | 161 | 0.7% | 161.07135578974 | 142 | 0.6% | 142.22877661051 | 163 | 0.7% | 162.54662238012 | 178 | 0.8% | 178.20932685151 | 163 | 0.7% | 162.85683138353 | 160 | 0.7% | 159.75288028557 | 167 | 0.8% | 167.1849777189 | 168 | 0.8% | 168.49930408549 | 172 | 0.8% | 171.52892449634 | 201 | 0.9% | 201.36598048825 |
Rental Charges | (45) | (0.2)% | -45.126850202327 | (41) | (0.2)% | -40.632304836736 | (43) | (0.2)% | -42.679075878677 | (42) | (0.2)% | -42.164201248427 | (43) | (0.2)% | -43.261215209747 | (45) | (0.2)% | -45.392301554922 | (44) | (0.2)% | -44.223472967602 | (44) | (0.2)% | -44.115677942142 | (45) | (0.2)% | -45.477029635592 | (46) | (0.2)% | -46.34262298484 | (46) | (0.2)% | -46.19567270715 | (48) | (0.2)% | -47.793123269791 |
Service Charges | (4) | (0.0)% | -4.443326341055 | (4) | (0.0)% | -3.762189686231 | (4) | (0.0)% | -4.006394416926 | (4) | (0.0)% | -3.948334887007 | (4) | (0.0)% | -4.019653827021 | (4) | (0.0)% | -3.70177081159 | (4) | (0.0)% | -3.596222100381 | (4) | (0.0)% | -3.5817814492 | (4) | (0.0)% | -3.678459553487 | (4) | (0.0)% | -3.804623386516 | (4) | (0.0)% | -3.783051435626 | (4) | (0.0)% | -3.832754225736 |
Rental Income | 3 | 0.0% | 3.310130675677 | 3 | 0.0% | 3.311294402677 | 3 | 0.0% | 3.311294402677 | 3 | 0.0% | 3.312294402677 | 3 | 0.0% | 3.312294402677 | 5 | 0.0% | 5.135104326865 | 5 | 0.0% | 5.168790159865 | 5 | 0.0% | 5.168790159865 | 5 | 0.0% | 5.168789659865 | 5 | 0.0% | 5.178572442292 | 5 | 0.0% | 5.178572442292 | 5 | 0.0% | 5.188085442292 |
Import Center | 1 | 0.0% | 0.985834491317 | 1 | 0.0% | 1.046319104333 | 1 | 0.0% | 1.126978991473 | 1 | 0.0% | 1.104998491852 | 1 | 0.0% | 1.19020040487 | 1 | 0.0% | 0.9885797072327 | 1 | 0.0% | 1.1392822748107 | 1 | 0.0% | 1.0785843297947 | 1 | 0.0% | 1.0748570294587 | 1 | 0.0% | 1.0288851128687 | 1 | 0.0% | 1.0573175194917 | 1 | 0.0% | 1.1777412705017 |
Depreciations / Amortizations | (28) | (0.1)% | -28.287084126536 | (26) | (0.1)% | -26.319500275602 | (29) | (0.1)% | -28.946130109632 | (29) | (0.1)% | -28.61389691058 | (30) | (0.1)% | -29.866634480442 | (30) | (0.1)% | -30.178605288836 | (31) | (0.1)% | -31.327961902151 | (31) | (0.1)% | -30.889701059576 | (31) | (0.1)% | -30.670022928621 | (32) | (0.1)% | -31.796352939542 | (31) | (0.1)% | -30.828839243453 | (32) | (0.1)% | -32.445368036673 |
Opening Fees | 6 | 0.0% | 6.1633795 | 0 | 0.0% | 0.4 | 1 | 0.0% | 0.915 | 2 | 0.0% | 2.478081025 | 11 | 0.1% | 11.134792837948 | 10 | 0.0% | 9.5469655503194 | 10 | 0.0% | 9.91964538636 | - | - | - | 8 | 0.0% | 8.132037799966 | 14 | 0.1% | 13.628374717 | 8 | 0.0% | 7.737801888596 | 7 | 0.0% | 7.069430083184 |
Pre-Opening Costs | (8) | (0.0)% | -7.6785148995 | (1) | (0.0)% | -0.5437700625 | (2) | (0.0)% | -1.7392761875 | (2) | (0.0)% | -2.2930170625 | (8) | (0.0)% | -7.5557628126 | (7) | (0.0)% | -7.2625324107554 | (10) | (0.0)% | -10.147207273 | - | - | - | (8) | (0.0)% | -7.860545244 | (11) | (0.0)% | -10.61032839 | (1) | (0.0)% | -1.3564094991887 | (14) | (0.1)% | -13.63148014051 |
Other Income / Expenses | (2) | (0.0)% | -1.73130977982 | (2) | (0.0)% | -1.53608977982 | (2) | (0.0)% | -1.801874542345 | (1) | (0.0)% | -1.29811902487 | (1) | (0.0)% | -1.46208902487 | (2) | (0.0)% | -1.64628345087 | (2) | (0.0)% | -1.56664331087 | (2) | (0.0)% | -1.68186331087 | (2) | (0.0)% | -1.74512345087 | (1) | (0.0)% | -1.46071331087 | (1) | (0.0)% | -1.335897178445 | (9) | (0.0)% | -8.648312748095 |
Operating result before HO Fees | 103 | 0.5% | 102.61484252057 | 71 | 0.3% | 71.436785345961 | 87 | 0.4% | 87.251878049445 | 71 | 0.3% | 70.806581397863 | 92 | 0.4% | 92.018554669659 | 106 | 0.5% | 105.69848291934 | 88 | 0.4% | 88.223041647046 | 86 | 0.4% | 85.731231014276 | 92 | 0.4% | 92.129481393245 | 94 | 0.4% | 94.320495348939 | 102 | 0.5% | 102.00274628096 | 108 | 0.5% | 108.45019886382 |
Head Office Fees | (9) | (0.0)% | -8.9406087472 | (7) | (0.0)% | -7.081147690809 | (8) | (0.0)% | -7.916455605524 | (8) | (0.0)% | -7.526770670315 | (8) | (0.0)% | -7.955252440098 | (9) | (0.0)% | -8.991800905116 | (8) | (0.0)% | -7.865635976864 | (8) | (0.0)% | -7.630248165313 | (8) | (0.0)% | -8.108653333702 | (8) | (0.0)% | -8.223235005109 | (8) | (0.0)% | -8.39987972216 | (9) | (0.0)% | -8.793280794114 |
Net Operating Result | 94 | 0.4% | 93.674233768483 | 64 | 0.3% | 64.355637654481 | 79 | 0.4% | 79.335422442765 | 63 | 0.3% | 63.279810726583 | 84 | 0.4% | 84.063302234378 | 97 | 0.4% | 96.706682013064 | 80 | 0.4% | 80.357405672186 | 78 | 0.4% | 78.100982848276 | 84 | 0.4% | 84.020828062034 | 86 | 0.4% | 86.097260338729 | 94 | 0.4% | 93.602866561305 | 100 | 0.5% | 99.656918072694 |
External Financial result | 7 | 0.0% | 6.5142060071633 | 7 | 0.0% | 7.0967799262913 | 7 | 0.0% | 7.0836932832333 | 7 | 0.0% | 7.3544546031233 | 7 | 0.0% | 7.469259248952 | 6 | 0.0% | 6.08516538913 | 7 | 0.0% | 6.823492218202 | 7 | 0.0% | 6.795259171822 | 7 | 0.0% | 6.612609265002 | 8 | 0.0% | 7.504787411042 | 7 | 0.0% | 7.402130125317 | 7 | 0.0% | 7.095594346637 |
Intercompany Financial result | 2 | 0.0% | 1.637368459772 | 3 | 0.0% | 2.741688148152 | 2 | 0.0% | 1.720247856908 | 1 | 0.0% | 1.261386864301 | 1 | 0.0% | 1.304861332864 | 1 | 0.0% | 1.256220268156 | 1 | 0.0% | 0.978687583407 | 1 | 0.0% | 1.16804434431 | 1 | 0.0% | 1.25558903089 | 1 | 0.0% | 1.34754474249 | 1 | 0.0% | 1.02445165417 | 1 | 0.0% | 1.09015396086 |
Financial Margin Reversal | (8) | (0.0)% | -8.1477655745751 | (7) | (0.0)% | -7.4234295092831 | (7) | (0.0)% | -7.2808229921336 | (7) | (0.0)% | -7.0638519103106 | (7) | (0.0)% | -7.1523813360575 | (7) | (0.0)% | -7.4570397285893 | (7) | (0.0)% | -7.1991669289406 | (7) | (0.0)% | -7.0237709905373 | (7) | (0.0)% | -7.3347086010893 | (7) | (0.0)% | -7.4426263368847 | (7) | (0.0)% | -7.4422129955425 | (8) | (0.0)% | -7.5840697359724 |
Result before Tax | 94 | 0.4% | 93.678042666928 | 67 | 0.3% | 66.770676222559 | 81 | 0.4% | 80.858540590861 | 65 | 0.3% | 64.831800283568 | 86 | 0.4% | 85.685041473913 | 97 | 0.4% | 96.591027941085 | 81 | 0.4% | 80.960418546028 | 79 | 0.4% | 79.040515374458 | 85 | 0.4% | 84.55431775545 | 88 | 0.4% | 87.506966153978 | 95 | 0.4% | 94.587235345554 | 100 | 0.5% | 100.25859664564 |
Tax | (10) | (0.0)% | -9.883613360493 | (6) | (0.0)% | -6.314484317829 | (8) | (0.0)% | -8.458760937215 | (5) | (0.0)% | -5.292943527533 | (7) | (0.0)% | -7.350037659063 | (11) | (0.0)% | -10.608368698855 | (9) | (0.0)% | -8.602115071794 | (10) | (0.0)% | -9.50155403257 | (9) | (0.0)% | -8.809700792262 | (8) | (0.0)% | -7.521288982826 | (7) | (0.0)% | -6.8754822614 | (8) | (0.0)% | -8.159048660997 |
Exchange Difference | (0) | (0.0)% | -0.25611371478334 | (0) | (0.0)% | -0.43435238258115 | (0) | (0.0)% | -0.3111525584015 | (0) | (0.0)% | -0.32052693612563 | (0) | (0.0)% | -0.32265257723454 | (0) | (0.0)% | -0.31140488701032 | (0) | (0.0)% | -0.27631049775231 | (0) | (0.0)% | -0.25072365162829 | (0) | (0.0)% | -0.16317573336298 | (0) | (0.0)% | -0.22586990795772 | (0) | (0.0)% | -0.43925560716871 | 1 | 0.0% | 0.51349583505194 |
Net Profit (Loss) After Tax | 84 | 0.4% | 83.538315590891 | 60 | 0.3% | 60.021839518571 | 72 | 0.3% | 72.088627093194 | 59 | 0.3% | 59.218329815839 | 78 | 0.4% | 78.012351233642 | 86 | 0.4% | 85.671254349626 | 72 | 0.3% | 72.081992976042 | 69 | 0.3% | 69.288237685461 | 76 | 0.3% | 75.581441229761 | 80 | 0.4% | 79.759807266846 | 87 | 0.4% | 87.272497473287 | 93 | 0.4% | 92.613043815675 |
EBITDA | 114 | 0.5% | 113.55743861098 | 83 | 0.4% | 82.817356037559 | 101 | 0.5% | 100.6895769999 | 85 | 0.4% | 84.509328786528 | 106 | 0.5% | 106.45490279133 | 119 | 0.5% | 119.11684268003 | 104 | 0.5% | 104.20989014838 | 102 | 0.5% | 101.71618926148 | 107 | 0.5% | 107.19296665475 | 110 | 0.5% | 110.22511703568 | 117 | 0.5% | 116.55023719865 | 125 | 0.6% | 125.03171220585 |