3 Replies Latest reply: Dec 14, 2015 4:34 AM by Ron Akkerman RSS

    full accumalation in a pivot chart over the rows

    Ron Akkerman

      Hi,

      I'll start with the script:

      Data:
      Load*,
      Year & '-' & Month As Period
      ;
      LOAD
      RowNo() as RowID,
      date(today() - RowNo(), 'DD MMM YYYY') as Date,
      Month(today() - RowNo()) as Month,
      Year(today() - RowNo()) as Year,
      floor(rand() * 1000, 2) as Value,
      right(RowNo(), 1) as Dim
      AUTOGENERATE(1000);

       

      I've two dimensions:

      1. Dim

      2. =Year & '-' & Month

       

      I use one expression to accumalate per Row

       

      rangesum(before(sum(Value),0, ColumnNo()))

       

      How can I get an accumaltion for all the Dim over all rows?