Table Calculation using stdev

kavirao · ‎2022-04-05

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.

any suggestions or help much appreciated

Thank you

vinieme12 · ‎2022-04-06

They below with Total keyword

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

kavirao · ‎2022-04-07

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