std at pivot or table chart

[coloful_architect]

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

[vinieme12 · Accepted solution]

as below

StDev(aggr(sum(sales),[Business Name]))

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Stati...