I have product data. what i need is coeff of variance = standard deviation/ Mean . Average is avg of revenue within the week. Std.dev is std.dev of revenue within the week.
Finally I have to show a bar chart with week number on x-axis and variance on y-axis.
variance numbers should change as we select product,type,week in filters .
Can anyone help me with this.
Can you make sure you get variance right when 'ALL' is chosen for product type. I used LOD but for 'ALL' option i am not getting right numbers.
I think the problem is for 'ALL' option, first i need group by product,type,week,all groups. and then again do a groupby calculation for avg and std.dev.
|Row Labels||Total Revenue|