Visibility agent for multiple dimensions
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
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!
Hi Ashwini, the solution is down below the mentioned blog entry :)
Please sign in to leave a comment.