How to do a Amount BIN ($0-100, $100-200) at order level

[#1]

Hello All,

I am trying to do a summary report with the following data.

        

The data is "line item level" and I would like create a BIN at order level.

ex. The sum of the first 3 records should be used for caluating the BIN.(Please refer to the report below)

           

Is there any way I could do  a calculated dimension with a group by clause or something?

Thanks,

A.Paul

[#2]

Data

To Be report

[llauses243]

Hi ,

You can to use CLASS, pls to see image adjust

Good luck, Luis