11 Replies Latest reply: Mar 6, 2018 12:51 AM by Raman Raghav RSS

    Cummulative sum with buckets in the dimension

    Raman Raghav

      How to build a logic for "cumulative sum "with buckets in Dimension in a tabular report 

      Dimension : [PAID RANGE NEW]

      Measure : amount

      Below is the inline table i created in the data load editor

      paid_period_12group:

      Load * inline

      [paid_period_id_new, "Paid Range New"

      1,'>$500M'

      2,'$500M - $100M'

      3,'$100M - $50M'

      4,'$50M - $10M'

      5,'$10M - $1M'

      6,'$1M - $500K'

      7,'$500K - $400K'

      8,'$400K - 100K'

      9,'$100K - $25K'

      10,'$25K - $2500'

      11,'$2500 - $100'

      12,'$100 - $0'

      13,'<$0'

      ];

       

      TIA