Hi,
sorry if this is a very simple question but I cannot figure it out.
I would like to a month average line to my pivot chart, but if I use the average function in excel, it will give me the average by each individual employee. how do I show a total month average?
I need it as a pivot chart as there is new monthly data so I'll be adding the timeline slicers.
<tbody>
</tbody>
Thanks in advance
sorry if this is a very simple question but I cannot figure it out.
I would like to a month average line to my pivot chart, but if I use the average function in excel, it will give me the average by each individual employee. how do I show a total month average?
I need it as a pivot chart as there is new monthly data so I'll be adding the timeline slicers.
Date (dd/mm/yyyy) | Employee | Total Amount | Month Average (excel) | Month Average (expected) |
01/01/2017 | A | 100 | 100 | |
02/01/2017 | B | 150 | 150 | 125 (Jan 17) |
02/02/2017 | C | 200 | 200 | 200 (Feb 17) |
01/03/2017 | D | 220 | 220 | 220 (Mar 17) |
<tbody>
</tbody>
Thanks in advance