Hi
I am compiling a slicer based dashboard on working days lost due to sickness. I have generated a pivot table with all the necessary data I need from one single source.
However, when I have generated my slicers, I have one for AWDL (days lost) and this only shows individual totals. Is there a way I can change the setting to show an average?
TIA
I am compiling a slicer based dashboard on working days lost due to sickness. I have generated a pivot table with all the necessary data I need from one single source.
However, when I have generated my slicers, I have one for AWDL (days lost) and this only shows individual totals. Is there a way I can change the setting to show an average?
TIA