Aggr and Sum for Bands

[stevejones1]

Here is my data :

Below is the aggregation of Gross pos by quarter , this for all the Products ,

I need to create  Bands based of Gross POS aggregated by each Product , so is the Gross POS for the Product is 3000$ it should fall under band"$1-$5000" so on ...

YearQuarter	Gross POS
2018Q4	($11,192,392.54)
2019Q1	($4,053,867.10)

Expected Output :

Product Discount Band          2018Q4            2019Q1

1-5000                                    $0.54M             $4000000M

5001-10000                            $192.392M       $53867.10M

10001-20000                          $11.00M             0

20001-50000                          $0.00                  0

50001-100000                        $0.00                  0

Any help on how i can achieve this?Attached app

Thanks

[shiveshsingh]

Please try with calculated dimension.

Attach reduced app plz

[qv_testing]

Try this.....

Load *, IF(Salary<=5000, '0-5000',

IF(Salary>5000 and Salary<=10000, '5001-10000',

IF(Salary>10000 and Salary<=20000, '10001-20000',

IF(Salary>20000 and Salary<=50000, '20001-50000',

IF(Salary>50000 and Salary<=100000, '50001-100000'))))) as SalaryBand;

Please try to attach small application...