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,
you could do something like: