Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
PFA.
Regards,
Kavita
What exactly are you counting here? This?
The second column..
So the first 11 rows meet your definition of Total Gross Revenue's 20% is less than or equal to gross revenue. How are you counting 118 here? I mean the 11th row itself is 120
What am I missing her?
20% is 13.6...
And we want those quantity whose gross revenue is 13.6 or less than 13.6..
So..
GRevenue Quantity
MAHINDRA 265 DI S PS | 0.2 | 4 |
MAHINDRA 415 DI PS CRPTO TRACTOR | 1.1 | 15 |
MAHINDRA 265 DI S MECH | 1.4 | 20 |
MAHINDRA YUVO 275 DI PS TRACTOR | 2.6 | 39 |
MAHINDRA YUVO 415 DI PS TRACTOR | 3.7 | 40 |
Total 9 118
You made this whole lot more complicated now
There is not straight forward way to do this, but see if this links help:
But i hope you understand my requirement better now..
I absolutely do.... but this require me to accumulate in a text box object which is not very straight forward as I would like
Can't be done really. Unless you precalculate stuff in the script and have QV 12 so you can use the sort feature of the aggr function. Or if you use actions that involve Pareto Select and messing about with alternate states.
Yup, I agree.... John and I came up with this two button strategy
Well I should not take credit for John's work here... John came up with this two button strategy