Visibility agent for multiple dimensions

Ashwini Sayani ·

 Hi, 

There are two dimensions in the crosstab (country, item)  and one measure, sales. 

I need to show the top 5 Airport Countries, with the top 10 Item Desc for each country. Is there a way of doing this using visibility agents or rank?

Please let me know

Thanks,

Ashwini

 

0

Comments

2 comments
Sort by DateVotes
  • Ashwini Sayani

    Rank for top list with multiple dimensions – TARGIT Community - I found this helpful, but how do I only display top 3 in the first dimension with top 5 in the second dimension, what would be the visibility agent calculation using rank? I have tried a few and they didn't work. Any help is appreciated! 

    0
  • Marlene Knaup

    Hi Ashwini, the solution is down below the mentioned blog entry :) 

    0
Please sign in to leave a comment.