This content has been marked as final. Show 2 replies
I have a requirement :
i have four fields:
1. Unit Numbers
Some Unit Numbers are having only 6 days data not all 7 days.
so i have to findout the unit numbers where the weekdays is less than 7, means not all 7 days present for particular unit.
i can find that in table using unitnumber as dimension & count(distinct week_day)<7 in expression. but i want the same in textbox.
i tried with aggr() but not got solution. If anybody have any clue.
Pls share asap.