I have a worry that this is not possible but anyway.
In attached file sheet pivot I have for cattegories and it's subcategories standard deviations of percentual differences. see highlighted in yellow ( as values)
then subtotal row is standard deviation (highlighted in red) but This is obviously nonsense to use and I would need instead to get average of standard deviation in yellow cells.
is this performable ?
In attached file sheet pivot I have for cattegories and it's subcategories standard deviations of percentual differences. see highlighted in yellow ( as values)
then subtotal row is standard deviation (highlighted in red) but This is obviously nonsense to use and I would need instead to get average of standard deviation in yellow cells.
is this performable ?