AlexandraT
Board Regular
- Joined
- Mar 23, 2015
- Messages
- 144
Hello,
I don't usually have to actually post a question here since I can usually find the answers I need in other posts. However, I am unable to find an answer now.
Here is my sample table:
<tbody>
</tbody>
Looks a bit silly but it should help with that I need. So what I would need is to know how many types of clothes are green but not red and vice versa. I would also like these split by month. Also, how many green only types of clothes come in both sizes and how many red only types of clothes come in both sizes. Also by month.
To illustrate what I need (without taking into account the month):
<tbody>
</tbody>
My data is some thousand rows long but there are 2 colours, 2 sizes and 4 months. There are thousands of types of clothes though.
I don't have any preference how this can be done, be it by additional columns, formula, pivot table or power pivot. But for the life of me I cannot figure it out and I can't seem to find anything online (granted I might not be searching properly).
Any help would be greatly appreciated. Thanks
I don't usually have to actually post a question here since I can usually find the answers I need in other posts. However, I am unable to find an answer now.
Here is my sample table:
Colour | Article | Size | Sold | ||
Green |
<tbody> </tbody> | 2 |
<tbody> </tbody> | ||
Green |
<tbody> </tbody> | 2 |
<tbody> </tbody> | ||
Green |
<tbody> </tbody> | 1 |
<tbody> </tbody> | ||
Green |
<tbody> </tbody> | 1 |
<tbody> </tbody> | ||
Green |
<tbody> </tbody> | 2 |
<tbody> </tbody> | ||
Green |
<tbody> </tbody> | 1 |
<tbody> </tbody> | ||
Green |
<tbody> </tbody> | 1 |
<tbody> </tbody> | ||
Green | T-shirt | 2 |
<tbody> </tbody> | ||
Red |
<tbody> </tbody> | 1 |
<tbody> </tbody> | ||
Red |
<tbody> </tbody> | 2 |
<tbody> </tbody> | ||
Red |
<tbody> </tbody> | 1 |
<tbody> </tbody> | ||
Red |
<tbody> </tbody> | 2 |
<tbody> </tbody> | ||
Red |
<tbody> </tbody> | 2 |
<tbody> </tbody> | ||
Red | Skirt | 1 |
<tbody> </tbody> | ||
Red | Socks | 1 |
<tbody> </tbody> | ||
Red | Socks | 2 |
<tbody> </tbody> |
<tbody>
</tbody>
Looks a bit silly but it should help with that I need. So what I would need is to know how many types of clothes are green but not red and vice versa. I would also like these split by month. Also, how many green only types of clothes come in both sizes and how many red only types of clothes come in both sizes. Also by month.
To illustrate what I need (without taking into account the month):
Green only | 2 | (Dress,T-shirt) |
Red only | 2 | (Shorts,Socks) |
Red 2 sizes | 1 | (Socks) |
Green 2 sizes | 1 | (T-shirt) |
<tbody>
</tbody>
My data is some thousand rows long but there are 2 colours, 2 sizes and 4 months. There are thousands of types of clothes though.
I don't have any preference how this can be done, be it by additional columns, formula, pivot table or power pivot. But for the life of me I cannot figure it out and I can't seem to find anything online (granted I might not be searching properly).
Any help would be greatly appreciated. Thanks