how to count rows grouped by text
I have a data like this:
And how to count rows grouped by text?
I want to get:
I can't change my data order, because I have group header in my report grouped by some condition.
1, text3
2, text2
3, text1
4, text1
5, text2
6, text1
And how to count rows grouped by text?
I want to get:
text1 - count 3
text2 - count 2
text3 - count 1
I can't change my data order, because I have group header in my report grouped by some condition.