I have a column called forecast variability which will calculate standard deviation of forecast values if a particular month has multiple forecast.
when i roll up or when i collapse the other category, i need to take the average of the std test values. But what it is doing is taking all the forecast values which is Aug 1 forecast, Sep 2, Oct 3 forecast values and taking standard deviation. which is not what i want.
You can see here it took standard deviation of all 6 forecast values, what i want is wherever i have forecast variability, those values should be picked and when i collapse the ‘other’ category it should give me the average of forecast variability which will be 447 in this case. But its taking the standard deviation of all the forecast values. Here is the calculated field for std test
Hello @Awan !
To clarify, when you collapse “Others” in the rows of your pivot table, you want your STD test to perform an average calculation?
Could you try changing the field level total option to average? This looks like its possibly set to minimum.
1 Like
Hello @Awan !
Do you still need help with this question or were you able to find a solution?
Hello @Awan !
This topic is being archived because it has been some time since we have heard from you. If you still need help please feel free to repost your question as a new topic at the top of the community.