2 Replies Latest reply on Sep 7, 2016 10:01 PM by Mahfooj Khan

    How to aggregate two measures, one based weekly and other overall

    shruti.c

      I have the following Dimensions and Measures in my data:

           1) Dimension = group ID, Week

           2) Measure = Cost1, Cost2

       

      I want to sum Cost1 by Group and Week in a Text Table. To the same table I want to add Average Cost2 for the weeks as a single column.

       

      Hence my results should be something like this:

       

      Group ID          Week1     Week2     Week3     Avg Cost2

      id1                     val1           val2          val3           val4

      id2                     val5           val6          val7           val8

       

      It is difficult to provide a sheet because i am using Live data having millions of row.