Challenge_20

Try to build the view same as below:

In this challenge, dimension selection showing  category wise total sales percentage

if sales above 35% means Green
and sales between 32% and 35% means Yellow
and sales below 32% means Red color.

Now dimension selection showing subcategory wise total sales percentage 

if sales above 10%  means Green

and sales between 5% and 9% means Yellow

and sales below 5% means Red.

Now dimension selection showing region wise total sales percentage 

if sales above 30% means Green

and sales between 20% and 30% means Yellow

and sales below 20% means Red.

 Now dimension selection showing shipmode wise total sales percentage 

if sales above 50% means Green

and sales between 10% and 50% means Yellow

and sales below 10% means Red.

If you crack the challenge send me the workbook or logic to this mail id:  

skrafi449@gmail.com