Want to find the StDev value

[Paknanarn23]

I have 10 values ​​in Spray field as shown in the figure. I want to find the StDev total of Panel Side = Top side regardless of Axis. In Excel, I would drag the mouse from Spart1 of Axis 1 to Spray1 and then spray10.

What should I do?

[Ben_P]

It depends on your data structure, and whether you want the result as a standalone KPI or as part of a table.

You say you have 10 values in the spray field, so I assume the data structure is something like this: 

In this case, if you want a KPI showing stdev for all Top side values, something like this should work:

if([Panel side]='Top side',stdev(Value))

[Paknanarn23]

I want to find all values ​​of Spray 1-10 ignoring Axis.

This is a formula in Excel.