Product Profit Bucketing By Color

[Anonymous]

Hi All,

We have a requirement in our project, i just replicated the sccenario using AdventureworksDB.

sample data:

https://jobatfresheronline-my.sharepoint.com/:x:/g/personal/admin_jobatfresheronline_onmicrosoft_com...

expected visual output:

https://jobatfresheronline-my.sharepoint.com/:i:/g/personal/admin_jobatfresheronline_onmicrosoft_com...

 

we have to calculate the number of products, which difference between sales and cost is >200000 ,

difference between sales and cost is <200000 and >100000

and <100000

Thanks..