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,

## Add comment