Hi guys,
It seems a silly question, but I was not able to find the answer and I've been researching for ours. I need to do 2 things:
1 - Count the # of rows and get the average of # if divided by months.
Ex.
| January | 1000 |
| February | 1200 |
| March | 400 |
| April | 1500 |
| May | 800 |
| June | 780 |
| Total | 5680 |
| Average | 947 |
I can't find the formula to calculate that.
2- I need to make this average static so I can use as baseline to compare what is the fluctuation Month over Month to display it in a graphic form.
How do I do that?
