Count with Mode function

[#1]

Hi

I am using the mode function to find out the item which was ordered many times with the same quantity during the project life cycle.

The expression that I used to compute the mode is

= mode  (aggr (sum(Quantity), Project, Item))

I need the count of mode in the aggregate output.

I am using this the above expression in the chart and I need to know how much percentage that the same quantity is used in the project.

Please help.

Regards

Mohamed Abubakker

[#2]

Mohamed,

i'am sorry, but your column 8 and column 10 formulas are strange gfor me.

In 1 column you calculate mode in 2'nd max(sum).

So, if you have for example data like this:

I1,P1,1

I1,P2,1

I1,P3,1

I1,P4,2

I1,P4,2

I1,P5,2

I1,P6,10

Your mode will give you null and then you will take 10 as result.

Starange for me... sorry

Anyway i will try to find solution how to calculate for each Item max number of project having the same sum(Amount). It is interesting

regards

Darek

[#3]

Mohamed,

this is solution i was looking for

For each Item number of projects with sum(quantity) having biggest occurance.

Result chart is with green background.

You can find also tablebox with loaded data, listboxes allowing to make some selections, 2 additional straight tables with additional rows and columns.

regards

Darek

[#4]

Hi Darek

You are correct. It is not working for more than one Item.

[#5]

Hi Liron

Please find the attachment.

As Darek mentioned, your solution is not working if there are more than one part number.

Kindly check.