pareto analysis

[sam_nik12345]

I have my tow tables as below. How can a do a 80-20 analysis with these? table1 & 2 are connected and matrl are mapped with reject qty.

table1:

matrl

a

b

c

d

e

f

g

 table2:

reject
100
80
74
67
54
44
32

[amitchandak]

@sam_nik12345 , what is the relation between 2 table?  How 80-20 will look like?

refer if these can help

pareto
https://www.youtube.com/watch?v=rlUBO5qoKow
https://powerbi.tips/2016/10/pareto-charting/
https://www.mssqltips.com/sqlservertip/6152/how-to-create-a-pareto-chart-in-power-bi-desktop/