Table Calculation using stdev

[kavirao]

Hi

I need to do calculation in table using stdev function. I could able to achieve it stdev but unable to use  it in expression inside  table

In total row i have sum and stdev value calculated using  stdev formula = Stdev(Aggr(Sum( num([sales]) * num([quantity])),company,QUARTER))

Now I need to use the stdev result in each row for calculation which I have formatted in Bold.  how to get stdev value in expression.

	Q1		q2		q3
company		stdev		stdev		stdev
total	25	11.18034	72	19.5269	45	20.12461
a	25	25/11.18034	1	1/19.5269	45	45/20.12461
b	0	0/11.18034	0	0/19.5269	0	0/20.12461
c	0	0/11.18035	40	40/19.5269	0	0/20.12462
d	0	0/11.18036	0	0/19.5269	0	0/20.12463
e	0	0/11.18037	31	31/19.5269	0	0/20.12464

any suggestions or help much appreciated 

Thank  you

[vinieme12]

They below with Total keyword

Stdev(total <QUARTER> Aggr(Sum( num([sales]) * num([quantity])),company,QUARTER))

[kavirao]

thank you so much it worked but still i couldnt able to get my requirement .

Based on STDev  I need to calculate Avg  of categories  for each Quarter  like below.  I need to plot that Avg into line chart. Any suggessions

Company	2020Q4			AVG	2020Q3			AVG	2020Q2			AVG	2020Q1			AVG
	CATEGORY1	CATEGORY2	CATEGORY3		CATEGORY1	CATEGORY2	CATEGORY3		CATEGORY1	CATEGORY2	CATEGORY3		CATEGORY1	CATEGORY2	CATEGORY3
A	90%	100%	100%	97%	90%	100%	100%	97%	90%	100%	100%	97%	90%	100%	100%	97%
B	98%	99%	100%	99%	98%	99%	100%	99%	98%	99%	100%	99%	98%	99%	100%	99%
C	100%	95%	100%	98%	100%	95%	100%	98%	100%	95%	100%	98%	100%	95%	100%	98%
D	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%
E	98%	99%	100%	99%	98%	99%	100%	99%	98%	99%	100%	99%	98%	99%	100%	99%
F	100%	95%	100%	98%	100%	95%	100%	98%	100%	95%	100%	98%	100%	95%	100%	98%