Hello,
I have an issue and i need your assistance
Situation is like this:
<tbody>
</tbody>
i need to have the average on the values from column " SoldQty(Kg) " in the table below.
Filter criteria is on Zone ( EU and US , and on sortiment type )
The result should look like:
<tbody>
</tbody>
average value for each of the sortiment ( APPLE, ONION , etc ) but for the corresponding Zone.
My idea was to use SUBTOTAL(101,range) to get the AVERAGE values even if the values are blank or text, and at the same time i need to make sure that i can have the criteria for the zone , i`m stuck at this now.
Any help is welcomed.
Thank you.
I have an issue and i need your assistance
Situation is like this:
Zone |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
EU |
<tbody> </tbody> | APPLE | 200 | |||
EU |
<tbody> </tbody> | ORANGE | 140 | |||
EU |
<tbody> </tbody> |
<tbody> </tbody> | 21 | |||
EU |
<tbody> </tbody> |
<tbody> </tbody> | 47 | |||
EU |
<tbody> </tbody> |
<tbody> </tbody> | ||||
EU |
<tbody> </tbody> |
<tbody> </tbody> | 589 | |||
EU | SHOP1 |
<tbody> </tbody> | ||||
EU | SHOP3 | APPLE | 34 | |||
EU | SHOP3 | ORANGE | ||||
EU | SHOP3 |
<tbody> </tbody> | 450 | |||
EU | SHOP3 | POTATO | ||||
EU | SHOP3 | GRAPES | 243 | |||
EU | SHOP3 | LEMON | n/a | |||
EU | SHOP3 | EGG | ||||
US | SHOP2 | APPLE | 230 | |||
US | SHOP2 | ORANGE | 144 | |||
US | SHOP2 |
<tbody> </tbody> | 200 | |||
US | SHOP2 |
<tbody> </tbody> | 85 | |||
US | SHOP2 |
<tbody> </tbody> | ||||
US | SHOP2 |
<tbody> </tbody> | 254 | |||
US | SHOP2 |
<tbody> </tbody> | n/a |
<tbody>
</tbody>
i need to have the average on the values from column " SoldQty(Kg) " in the table below.
Filter criteria is on Zone ( EU and US , and on sortiment type )
The result should look like:
Zone | Sortiment | Average | |
EU | APPLE | ||
ORANGE | |||
ONION | |||
POTATO | |||
GRAPES | |||
LEMON | |||
<tbody> </tbody> | |||
US | APPLE | ||
ORANGE | |||
ONION | |||
POTATO | |||
GRAPES | |||
LEMON | |||
EGG |
<tbody>
</tbody>
average value for each of the sortiment ( APPLE, ONION , etc ) but for the corresponding Zone.
My idea was to use SUBTOTAL(101,range) to get the AVERAGE values even if the values are blank or text, and at the same time i need to make sure that i can have the criteria for the zone , i`m stuck at this now.
Any help is welcomed.
Thank you.