Hi All,
I am trying to build a dashboard on ABC analysis, where we classify the materials as Category A (80%), Category B(15%) and Category C (5%).
In the filter pane, I am trying to show a Range % which should show how much % (ex 10%, 20%, 30% etc upto 100%), total unique materials, unique suppliers is contributing to the respective Range %,. If i select upto 50%, it should show all the material details until 50% i.e upto 10%+20%+30%+40%+50%.
I tried the following in the data load editor but it is not giving the correct result.
if("Total %"<=10,'upto 10%', if("Total %">10 and "Total %"<=20, 'upto 20%', if("Total %">20 and "Total %"<=30, 'upto 30%',
if("Total %">30 and "Total %"<=40, 'upto 40%', if("Total %">40 and "Total %"<=50, 'upto 50%', if("Total %">50 and "Total %"<=60, 'upto 60%',
if("Total %">60 and "Total %"<=70, 'upto 70%', if("Total %">70 and "Total %"<=80, 'upto 80%', if("Total %">80 and "Total %"<=90, 'upto 90%',
if("Total %">90 and "Total %"<=100, 'upto 100%')))))))))) as range
i tried this also but no correct results.
if(rangesum(peek("Percentage %"),rowno())<=10.00,'upto 10%',
if(rangesum(peek("Percentage %"),rowno())>10.00 and rangesum(peek("Percentage %"),rowno())<=20.99,'upto 20%',
if(rangesum(peek("Percentage %"),rowno())>20.00 and rangesum(peek("Percentage %"),rowno())<=30.99,'upto 30%',
if(rangesum(peek("Percentage %"),rowno())>30.00 and rangesum(peek("Percentage %"),rowno())<=40.99,'upto 40%',
if(rangesum(peek("Percentage %"),rowno())>40.00 and rangesum(peek("Percentage %"),rowno())<=50.99,'upto 50%',
if(rangesum(peek("Percentage %"),rowno())>50.00 and rangesum(peek("Percentage %"),rowno())<=60.99,'upto 60%',
if(rangesum(peek("Percentage %"),rowno())>60.00 and rangesum(peek("Percentage %"),rowno())<=70.99,'upto 70%',
if(rangesum(peek("Percentage %"),rowno())>70.00 and rangesum(peek("Percentage %"),rowno())<=80.99,'upto 80%',
if(rangesum(peek("Percentage %"),rowno())>80.00 and rangesum(peek("Percentage %"),rowno())<=90.99,'upto 90%',
if(rangesum(peek("Percentage %"),rowno())>90.00 and rangesum(peek("Percentage %"),rowno())<=100.99,'upto 100%')))))))))) as Range%
I have attached the data file for your reference.
Please help.
Regards
Vani
