Now I want to count the text values at Col3 based on aggregation of Col2. Thw result should be the following table:
To get Date, Col1 and Col2 I can simply filter Date, where Col1 is not null. Or I use directly a filter for Col1. But how can I count the text values at Col3, when I filtered the Date before? I thought of something with set analysis.
Thanks for your proposal. For me it is not working and I dont know why.
I also dont understand, why you use Aggr function to filter the dates? I used the dollowing filter:
If(not IsNull(Col1), Date) or If(Len(Col1) > 0, Date)
Nevertheless both variants are not working for me.
I changed the base data table a little bit. I added two more rows (Date21 and Date 131). As you can see, it could also be, that there are addional entries for Col3 -> Date131. But they have a different value of Col2. So they should not be counted.