Calculate 1 year when only 1 month is selected

[Anonymous]

Hi Guys,

I would like to ask for your help regarding my problem.

Please let me explain my problem brielfly:

This is my data for 2 years:

2011:

Group	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
A	100	110	120	130	140	150	160	170	180	190	200	210
B	150	160	170	180	190	200	210	220	230	240	250	260
C	200	210	220	230	240	250	260	270	280	290	300	310

2012:

Group	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
A	80	90	100	110	120	130	140	150	160	170	180	190
B	130	140	150	160	170	180	190	200	210	220	230	240
C	180	190	200	210	220	230	240	250	260	270	280	290

Formula:

Sales Ratio = Sum Sales this month divided by Sum Sales of the whole year

(ex. If user selects Aug-2012,then Sum (Sales for Aug 2012) divided by Sum (Sales from Aug 2011 to Aug 2012).

Catch:

User wants only to select Aug 2012 in the listbox. Now the user wants to see the result of Sales Ratio. The answer should be: 0.080213903

Question:

What will my expression look like?

Thanks in advance and godbless!

Gerald

[Anonymous]

Hi Sushil,

The attachments is located in the original pos. Thanks in advance!

Regards,

Gerald

[amars · Accepted solution]

See if the attached file helps.

Thanks Amar

[Anonymous]

Hello amars,

"See IF the attached file helps".... IT REALLY HELPED!!! Talk about humility.

Thank you very much. The formula that you've used is correct.

Thank you my friend,

Gerald