Calculate Top 40%

[Anonymous]

Hi All,

I want to calculate the Count for Top 40 % by tons using set analysis for Material Type (ABC) .I have attached excel file.

Thanks in advance.

[omkarvamsi]

Hi Satya,

Please elaborate your issue.

On which basis percentage is calculated.

i couldn't able to understand "Count for Top 40 % by tons "

you need which count?

[Anil_Babu_Samineni]

Do you mean < 40%

Sum({<Value(Count of Tons) = {'<= 40.00 %'}>} Tons)