5 Replies Latest reply on Jun 30, 2014 10:29 PM by Prashant Sharma

    How do I group data into bands using a measured field?

    Dianne Britt


      I am trying to create a cross-tab report that groups data using a measured field.  Specifically, I have a measure of cost/load and a measure of miles/load.  I would like to aggregate all the data of miles/load into groups of every 10 miles (1-10, 11-20, 21-30 etc) and then calculate the cost/load for each of those bands.  I have looked at Parameter, Groups, Sets but don't see anything like this.  Does anyone know if this can be done and can point me to some instructions on how?

       

      Thanks