Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 ??