Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
1) I am working on pivot table where i have multiple calculation involved like stdev and z-score.
Below is the sample table where I need to calculate stdev for Q1 , Q2, Q3, Q4 so it has to pass values of company into stdev function stdev(8,2,0,0,0) for Q1 etc.... ( the values in pivot table used formula with few conditions)
That result I need to store in array where i can use for z-score
| Company | Q1 | Q2 | Q3 | Q4 |
| A | 8 | 4 | 0 | 7 |
| B | 2 | 0 | 5 | 2 |
| C | 0 | 3 | 0 | 0 |
| D | 0 | 0 | 2 | 0 |
| E | 0 | 2 | 0 | 4 |
| F | 1 | 0 | 3 | 2 |
| Total | 11 | 9 | 10 | 15 |
| Stdev |
Like below
stdev(TOTAL <Quarter> aggr( sum(Xyz) , Company,Quarter))