Aggr with Unit Numer

[#1]

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..!!!

[Peter_Cammaert]

What do you want to put in this text box? A long list of comma-separated Unit numbers? Then use:

=Concat(aggr(...))

[Gysbert_Wassenaar]

Perhaps like this: =concat({<[Unit Numbers = {'=count(distinct Weekdays)<7'} ]>} distinct [Unit Numbers], ', ')