Create Rank based on Total % Values

[dmohanty]

SupplierSpend:

load * inline

[

SupplierID, Spend

101, 20k

201,35k

301,40k

401,18k

501,22k

601,31k

701,42k

801,25k

901,39k

];

Hi All,

Above is the raw data set.

REQUIREMENT:

I need to create a Chart, that would show the Groups of the Supplier based on some criteria. Below is the criteria:

Group 1: All Supplier ID that consists of Top 80% of total Spend values

Group 2: Next 15%

Group 3: Last 5%.

SO, the chart may look like this below (ignore the calculation shown below; just a representation). Please help me in this.

Group	SupplierID	Rank
A	701	1/4
	301	2/4
	901	3/4
	201	4/4
B	601	1/3
	801	2/3
	501	3/3
C	101	1/2
	401	2/2

Regards!

[jer_2011]

Hola,

Gracias por tus elogios, espero me puedas entender, el Rank lo tomo como base de tu primer solicitud, esta el ejemplo en el mismo qvw que te mande, solo dale expandir ahí podrías observar como esta armado, esto quedaría así

por lo tanto queda asi

SupplierID = 301

Month  Group    Rank

Jan          A        3 / 3

Feb          A        1 / 3

Mar          A        2 / 3

Apr          A         3 / 3

.

.

.

espero te sea de utilidad, y se necesitas otro tipo de Rank, solo indícame y lo intentamos

saludos

[dmohanty]

Hey Gerardo,

Greetings! Yes I can understand you (though by Google translator ).

Apologies for the delay in reply, as I didn't get a chance to work/look on this. Many more thanks again for a detailed explanation to my query. I got your point of solution now. You have the CountGroup based on the no. of Groups for each month.

However I needed in a reverse way. My need was the CountGroup should be based on Months.

For example,

ID = 301 from Group = A has 8 months, I was expecting the CountGroup to be 8 and we would have 8 Ranks.

Hope you understood. Is it possible?

Thanks in advanced!

[jer_2011]

Hola nuevamente

te paso nuevamente el ejemplo, la idea es entenderle a la función peek()

saludos espero te sirva