Set Analysis and Slider

[passionate]

I have list of products, cost price and selling price.

There is use case to filter out products on front end with slider.

Eg:- If i select slider as 20 Percent than product having profit less than or equal to 20 percent should be filtered.

Products should be filtered on whole dashboard in all the calculations. i.e KPI, etc

Please help me with some front end solution.

[kaushiknsolanki]

Hi,

Check this out.

Regards,

Kaushik Solanki

[sunny_talwar]

May be create a OnChange Variable Event Trigger for vProfit where you trigger Select in Field on ProdCountry field (a new field created in the script) using the following expression

='=Only({<ProdCountry>} ([Selling Price]-[Cost Price])/[Cost Price]) <= vProfit/100'

Script for ProdCountry

LOAD ProductID, 
     Product, 
     [Cost Price], 
     [Selling Price], 
     Country,
     Product&Country as ProdCountry
FROM
[Slider Data.xlsx]
(ooxml, embedded labels, table is Sheet1);