How to calculate Contribution in straight table?

[#1]

Hello,

Can any one tell me how to calculate contribution in straight table.

Region	Mar-12 Sale	Contribution %
Total	2,403
E	1,312	54.6
U	730	30.4
SA	219	9.1
AF	21	0.9
AUS	60	2.5
LAT	50	2.1
ASIA	11	0.9
MIDDLE EAST	0	0.0

Here, i am using following expression for calculating Mar-12 sale

(SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[PostDate]=">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Post Date]))"}>}[G_Amount]))

/100000)

Thanks.....

[Gysbert_Wassenaar · Accepted solution]

Try:

(SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[PostDate]=">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Post Date]))"}>}[G_Amount]))

/100000)

/

(SUM(TOTAL {$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[PostDate]=">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Post Date]))"}>}[G_Amount]))

/100000)

[vikasmahajan]

You can also create Variable  vSAL

vSAL =  (SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[PostDate]=">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Post Date]))"}>}[G_Amount]))

/100000)

Contribution Column

((SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[PostDate]=">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Post Date]))"}>}[G_Amount]))

/100000)/vSAL)*100

HTH

Vikas

[#4]

Thank you so much Gysbert & Vikas sir  for the solution .....