deadlyliquidx
New Member
- Joined
- Feb 6, 2015
- Messages
- 27
Hello Guys!
I have a problem in which I need to count unique/ distinct (i dunno which one), values that do not duplicate and have a sold value greater than 0 for a certain month.
Ex:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I have a problem in which I need to count unique/ distinct (i dunno which one), values that do not duplicate and have a sold value greater than 0 for a certain month.
Ex:
Month | Animal | Sold |
JAN | Dog | 1 |
JAN | Dog | 1 |
JAN | Cat | 1 |
JAN | Man | 0 |
FEB | Cat | 1 |
FEB | Dog | 1 |
FEB | Cat | 1 |
FEB | Cat | 1 |
FEB | Man | 0 |
FEB | Man | 0 |
FEB | Ant | 1 |
FEB | Spider | 1 |
FEB | Spider | 1 |
Mar | Dog | 0 |
Mar | Dog | 0 |
Mar | Dog | 0 |
Mar | Dog | 0 |
Mar | Dog | 0 |
Mar | Dog |
<colgroup><col><col><col></colgroup><tbody>
</tbody>