Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have QV11 and I am trying to get a list of 10 revenues by Region. In a straight table and a pivot table.. Need to get the same ranking as in the attched file in QV and I have no idea how to do it.
Please Help!
You can use the dimension limits to select only the Top X elements from a dimension based on the first expression. Also you could use the Expression in the sort order for the same dimension, in descending order. This way you will have a top 10 list ordered.
Hope this helps