Show top 5 customers based on sales, and their top 5 items?

[fishy]

Hello! 

I was wondering if anyone can help my with a question. 

I need to show top 5 Customer based on Sales, and also display their 5 most bought Items. 

I've tried putting all 4 columns into a table, with count(item) and sum(Sales) as measures. However, limitation only works with one measure. How can I make my dimension based on two different measures? 

I've tried with If(Rank(Sum([Sales Margin Amount])) <= 5, count(Customer)), but I doesn't limit my top 5 customers. 

Thanks in advance! 

[Anil_Babu_Samineni]

Perhaps this?

If(Rank(Sum({<Customer={"=Rank(Sum())<=5"}>} [Sales Margin Amount])) <= 5, count(Customer)) // I assume this is expression, not dimension.

If that is calculated dimension try this

Aggr(If(Rank(Sum({<Customer={"=Rank(Sum())<=5"}>} [Sales Margin Amount])) <= 5, count(Customer)), Customer)

[AkashPatil]

Concate(Distinct If(Aggr(Rank(Sum(Salesammount)),CustomerName)<=5,Aggr(Rank(Sum(Salesammount)),CustomerName) & ' -'  & CustomerName