Filter on Dataview

unknown

Hi BOARD Community,

I have a question on the Filter options.
In the current dataview I get the top 10 negative Contribution Margins Countries per Publisher.

I am looking for a way to show the top 10 negative Countries overall but still keep the Publisher connection. So in the end I want to have just 10 entries in total. 

For Example:

Publisher 1:
1. Germany
2. India
3. Venezuela

Publisher 2:
4. England
5. Germany

Publisher 3:
6. Laos
7. Argentina
8. Belgium
9. Greece
10. Germany

Is there a way to get this done?

Thanks

Mathias

------------------------------
Mathias Flintrop
Senior Financial Controller
Smaato Inc
Germany
------------------------------

Helmut Heimann

Hi @Mathias Flintrop,

sorry for the late reply.
My idea would be to first calculate the 10 Flops in a dataflow and mark those countries in a select cube which you then can use to filter your data.
It can be that you'll need a second entity for your countries which is not connected to the publishers. That would of course complicate matters--but, after all, that's just an idea, I would try out.

Kind Regards,
Helmut

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------