Is there any way (besides power pivot or fields calculated outside the pivot) to calculate the coefficient of variation (standard deviation/average) in a pivot table? When I create a calculated field with
=STDEV('Field')/AVERAGE('Field')
it doesn't give me any values in the pivot table.
I appreciate your help!