Hello 

The rank statistical feature returns the rank of a member in the specified list. The list used must be a list or set of elements from the SAME hierarchy as the member in the model. I want to know if there is a way to create formulas for:

1. Ranking the sales of a company products (The formula must include the company rankings for sales per product) 

2. Ranking the sales of all regional companies (The formula must include the other companies rankings for sales per product)

I want to be able to compare the ranking of sales per product per company to the ranking of sales per product of the other companies using two formulas.  

I am able to use the ranking formula in a report focussing on a company and in a report focussing on the other companies BUT in the one report I want to compare the single company with the other companies rank per sales per product.

I am sure that I am missing something obvious but will value any assistance

 

Thank you