9 Replies Latest reply: May 7, 2015 9:22 AM by Piet Hein van der Stigchel RSS

    How to group and sum every nth values?

    Christian Veinfors

      I would like to "collapse/group" every nth values for a dimension and measure. I want the values in every "group" to be summarized as illustrated below.

       

      newtable.png

       

      I need it to be dynamic (work with different group sizes) so it can't be done in the load script.

      How can I achieve this?