Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I wanna build a measurement/column at pivot table or plain table chart for standard deviation.
sth like this below;
[Business Name] | [Business Name Key] | Product A | Product B | Product C | Product D | Product E | Product F | Std ??? |
1.85% | 27.85% | 38.35% | 18.02% | 1.17% | 12.76% |
This is a pivot table chart where dimensions are business name, business name key and measurement is
Sum([sales])/Sum(total<[Business name Key]>[sales])
how my measurement I should set to achieve a std number ? the number should be 14.64%
thanks
as below
StDev(aggr(sum(sales),[Business Name]))
as below
StDev(aggr(sum(sales),[Business Name]))