Skip to Content
0
Sep 30, 2017 at 01:54 AM

12 months Trend Formula

74 Views

Hi,

Can you please advise me to create the formula. I need to calculate the 12 months Trend formula for my chart.

The requirement is

For Example

Table A (1st Month) Table B (2nd Month) Table C(3rd Month)

Review Rev# Review Rev# Review Rev#

AAA 10 AAA 10 AAA 10

DDD 20 DDD 20 DDD 20

XXX 10 XXX 10 XXX 10

I need to calculate Average # of Reviews.

If the user runs the report for one month then the calculation would be

for AAA the formula would be = 10 /40 (Table[A] AAA+ Table[A] DDD+ Table[A] XXX)

for DDD the formula would be = 20 /40 (Table[A] AAA+ Table[A] DDD+ Table[A] XXX)

If the user runs the report for two month then the calculation would be

AAA 10 + AAA 10 = 20 /80

DDD 20 + DDD 20 = 40/80

If the user runs for the 3 months then the calculation would be.

AAA 10 + AAA 10 + AAA 10 =30 / 120

DDD 20 + DDD 20 + DDD 20 =60 / 120

The Report runs based on the Element Linking if the user clicks AAA for the 1st Month then the Chart should change as per the blow formula.

AAA 10 + AAA 10 = 20 /80

If the user clicks DDD for the 1st Month then the Chart should change as per the blow formula.

DDD 20 + DDD 20 = 40/80

Please help me to write the Formula

Thanks,