Would like to ask if it is possible to apply rank function and then filter to two fields without messing up each of those ranks?
To be more specific, one of rank is to order the sum of sales by product code whilst the other is to order sum of sales by customer. And the analysis requirement is to filter top 30 product code and top 5 customer contributing to most sales (i.e. sum(sales).
Have tried Union feature from analysis criteria, but seems doesn't work.
Please advise any potential features/functions/strategies which may apply to this analysis. MILLION THANKS!!!