I ofte have the problem that I want to show a special selection in a dataview (or top ten) and all the others (remainders) as one position. I know there is a Nexel conclusion but is there a smarter more simple option?
Dear Annika Fava,
another option, but I don´t think that it is easier is calculating separate Cube just for the top 10 customers.
When you insert this plus the normal cube into your layout you just have to deduct the top10 from the normal cube and git the wished result.
But for that you have to run procedure, need a second cube and have to think for the best slot calculating your separate cube.
I think for all that constraints the nexel solution is the bette one.
Hope it helps
Hi Annika Fava
You may like to look at this post How to create view with Top X values + 'Others' grouped in one value by Robert Brooke last year.
By analysing Robert's solution, you may find that you can devise a number of different ways of achieving what you want and applying them in more versatile ways. And, as Ray Martens demonsterates very well, it opens the 'crossview' feature to those not aware or sure of it.
Hope this helps.
Retrieving data ...