pie chart with calculation dimension

[TarekHajji]

Hello , I have a table with two columns IdProduct and price

How can i show a pie chart that count the percentage of the product with price < 30, 

the percentage of the product with price >30 and < 100,

the percentage of the product with price > 100

Thank you for your helps

[Kushal_Chawda · Accepted solution]

Create pie chart with

Dimension : Valuelist('Price<30','Price>30<100','Price>100')

Expression:

Pick(match(Valuelist('Price<30','Price>30<100','Price>100'),'Price<30','Price>30<100','Price>100'),

Count({<Product ={"=Sum(Price)/Sum(Total Price)<0.3"}>}distinct Product),

Count({<Product ={"=Sum(Price)/Sum(Total Price)>0.3 and Sum(Price)/Sum(Total Price)<1"}>}distinct Product),

Count({<Product ={"=Sum(Price)/Sum(Total Price)>1"}>}distinct Product))