7 Replies Latest reply: Jun 22, 2015 11:39 AM by Mark Graham RSS

    Grouping dimensions in Chart table

    Mark Graham

      Hi,

       

      I'm trying to group SKU, SUm(Units Packed), and Count(Locations) by Warehouse.

      Aggr(Count(Distinct(SKU#)), [Warehouse])

      Aggr(Sum([Units Packed]), [Warehouse])

      Aggr(Count(LBCD), [Warehouse])

       

      I'm not sure, whether this is right.

       

      On the other hand, i'm trying to group SKU, SUm(Units Packed), and Count(Locations) by Warehouse

      whose 360-day velocity Weeks on Hand is less than 8 and greater than 0.


      If($(v360-day Velocity WOH)>=0 and $(v360-day Velocity WOH)<=8, Aggr(Count(DISTINCT(SKU#)), Warehouse))

      If($(v360-day Velocity WOH)>=0 and $(v360-day Velocity WOH)<=8, Aggr(Sum([Sum of Units packed in recent 30 days]), Warehouse))

      If($(v360-day Velocity WOH)>=0 and $(v360-day Velocity WOH)<=8, Aggr(Count(LBCD),Warehouse))

       

      Please lemme knw the expressions accuracy.