1 2 Previous Next 24 Replies Latest reply on Jul 5, 2018 7:10 PM by Shinichiro Murakami

# Rank for Count of Products

Hi Team,

I am having requirement like, list of  count of products-Good Sales and  count of products-Bad Sales for manufacturers,  Here i am unable to sort  good Sales  field n descending order.

i would like to see top N manufacturers for count of Products-Good Sales only.

• ###### 1. Re: Rank for Count of Products

Hi Anand

Hope this helps,

Thanks,

Shin

1 of 1 people found this helpful

• ###### 3. Re: Rank for Count of Products

Hi Anand

You are very welcome.

Shin

• ###### 4. Re: Rank for Count of Products

I am trying convert from count to percentage.

Example: if a manufacturer contain 100, product count 50 Bad product sales = 50% and another 50 Good Product sales =0%.

Thank you

• ###### 5. Re: Rank for Count of Products

Could you explain this logic in detail?

1 of 1 people found this helpful
• ###### 6. Re: Rank for Count of Products

i am really sorry, its typo error.

Example: if a manufacturer contain 100, product count 50 Bad product sales = 50% and another 50 Good Product sales =50%.

• ###### 7. Re: Rank for Count of Products

Hi Anand

I don't know how to handle Top N or sorting, but anyways.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 8. Re: Rank for Count of Products

Hi

huge round of applauds for your response:

TOP  N Manufacturer parameter is not working as per the requirement, i am able see the desc sort order but its not adhere to the only good products TOP N %.

Can you please look into this.

Thank you

• ###### 9. Re: Rank for Count of Products

Hi

with your guidance i am able to develop one chart using LOD, but i am unable to find the sorting option and Top N Manufacturers in sheet.

Thank you

• ###### 11. Re: Rank for Count of Products

HI Anand

I am not sure but you may want to set criteria of good/no good by aggregated level, not record level??

If so, you need to change all the formula.

If Not, I con't understand how you want to handle duplicated criteria (same products have both good and Not good)

Thanks,

Shin

1 of 1 people found this helpful
• ###### 12. Re: Rank for Count of Products

Hi Shin,

Thank you very much for your reply, with your guidance i am able to achieve what i want to do. Finally i would like to know how to take top N Good Sales Manufacturers on the sheet.

Please find attached twbx file and let me know how to consider top N Good Sales Manufactures. I really appreciate your help.

Thank you

• ###### 13. Re: Rank for Count of Products

1 of 1 people found this helpful
• ###### 14. Re: Rank for Count of Products

Hi Shin,

Just to bring to your notice, if i selected by sub-category even the manufacturer should populate top N percentage.

But now i am not able to populate the same. i am missing some product percentage.

Can you help me with logic.

Thank you

1 2 Previous Next