Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement :
i have four fields:
1. Unit Numbers
2. WeekDays
3. PeriodNumber
4. WeekNumber
5. Sales
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.
Thanks..!!!
What do you want to put in this text box? A long list of comma-separated Unit numbers? Then use:
=Concat(aggr(...))
Perhaps like this: =concat({<[Unit Numbers = {'=count(distinct Weekdays)<7'} ]>} distinct [Unit Numbers], ', ')