How to show remainders as one position others in a dataview?

Annika Fava
Annika Fava Customer
Third Anniversary First Comment 5 Likes
in Platform

Hello,

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?

 

KR

Annika

Answers

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers

    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

     

    regards

     

    Alexander Kappes

  • Paul Wyatt
    Paul Wyatt Customer
    100 Comments 100 Up Votes 100 Likes Second Anniversary

    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.

     

    Regards,

    Paul

Categories