Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please try with calculated dimension.
Attach reduced app plz
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...