Associated group

[qingkong]

I have two sheets sheet1 associated with Sheet2 and returned the field "Qty/AVG6

Want to group field "Qty/AVG6"

The results are shown in the attached picture

I have used ValueList and Aggr without success

I have uploaded the attachment, please help, thank you

 

Expressing effect

[vinieme12]

Load

number

,Qty

,Avg6

,if((Qty/Avg6)>9,'>9',if((Qty/Avg6)>6,'6-9',if((Qty/Avg6)>6,'6-9',,if((Qty/Avg6)>3,'3-6','1-3')))) as interval 

From Yourexcel....;

From  

[qingkong]

Dear:

I'm sorry I forgot to explain

Sheet1 and Sheet2 are loaded separately and not together

[cid:image001.png@01D85B05.15E56970]

[vinieme12]

Can you also explain the relation between sheet 1 and Sheet 2? how are they associated actually?

Why should Qty value 2905 be divided by Avg6 value 376 and not 511 or 445 ??