alignment with Pivot Table

[Anonymous]

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

[jsingh71]

Can you share some dummy Data.

[Anonymous]

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