0 Replies Latest reply: Jun 29, 2016 4:04 AM by Heiko Tietze RSS

    Cross Aggregation

      My data look like this:

       

      Global_IDLocal_IDRefTypeLabelnT1nT2nT3
      20160815913514-1Foo111
      20160815913515-1Bar111
      20160815913516-1Bar111
      201608159135179135142-
      201608159135189135152-
      201608159135199135162-
      201608159135209135173-
      201608159135219135183-
      201608159135229135193-
      2016081612345

       

      There is a variable number of type=1 per Global_ID. Each T=1 can have a number of T=2, which again holds a couple of T=3. Variables nT1 to nT3 is what I want to achieve in order to pivot all data (total number and average of type=2 and 3 per Label). When I aggregate now per Aggr(Sum(if([Type]=2,1,0)),[Ref]) these values are not written into the line with the label. Any idea how to do this "cross aggregation"? (Didn't find a better caption)