2 Replies Latest reply: Nov 17, 2014 10:31 AM by Gysbert Wassenaar RSS

    Aggr with Unit Numer

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