Forum Discussion
Help trying to get averages
Hi all, Apologies if I have posted this in the wrong section. I have a situation where I need to get a few different averages, and they all come from the same source data, in a table called...
Hi
Basically looking for something that would allow me to get the averages which would be affected by the date slicer as well.
Based on the example data that I have posted I would expect to see that
Sector 1 has an Average of 2
Sector 2 has an Average of 1.5
Sector 3 has an Average of 1.5
But if I was to use the Date slicer and remove the December record I would expect to see
Sector 1 has an Average of 2
Sector 2 has an Average of 1.5
Sector 3 has an Average of 1
Let me know if you need anything else.
Thanks